USP_SIMPLEDATALIST_INTERACTIVEGIVINGLISTINBOUNDCHANNEL

CREATE procedure dbo.USP_SIMPLEDATALIST_INTERACTIVEGIVINGLISTINBOUNDCHANNEL as
    select 
        ID as VALUE, 
        DESCRIPTION as LABEL
    from dbo.CHANNELCODE
    union
    select 
        cast(cast(0 as binary) as uniqueidentifier) as VALUE, 
        'No Revenue Channel' as LABEL
    order by DESCRIPTION