USP_SIMPLEDATALIST_SPONSORSHIPREASONBULKTRANSFER

create procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPREASONBULKTRANSFER
     as
    select 
        ID as VALUE, 
        case REASONTYPECODE when 1 then 'Child - ' + REASON
                            when 2 then 'Project - ' + REASON
                            when 4 then 'Location - ' + REASON
                            when 5 then 'Transfer - ' + REASON
        end LABEL
    from 
    dbo.SPONSORSHIPREASON
  where 
    REASONTYPECODE in (1,2,4,5)
    order by REASONTYPE