USP_DATALIST_SPONSORSHIPREASON

CREATE procedure dbo.USP_DATALIST_SPONSORSHIPREASON
as
    set nocount on;

    select 
        ID,
      REASON,
      REASONTYPE = case when TRANSFERSPONSORSFORINELIGIBLECHILD = 1 and REASONTYPECODE = 1 then 'Child - Mark ineligible (Transfer sponsors)'
                         when TRANSFERSPONSORSFORINELIGIBLECHILD = 0 and REASONTYPECODE = 1 then 'Child - Mark ineligible (Keep sponsors)'
                         when TRANSFERSPONSORSFORINELIGIBLECHILD = 1 and REASONTYPECODE = 2 then 'Project - Mark closed (Transfer sponsors)'
                         when TRANSFERSPONSORSFORINELIGIBLECHILD = 0 and REASONTYPECODE = 2 then 'Project - Mark closed (Keep sponsors)'
                         else REASONTYPE
                    end,
    TRANSFERSPONSORSFORINELIGIBLECHILD                
    from dbo.SPONSORSHIPREASON 
    order by REASON