USP_SIMPLEDATALIST_PDACCOUNTCODEMAPPLANNEDGIFT_REVOCABLESTATUS

create procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPPLANNEDGIFT_REVOCABLESTATUS
(
    @PDACCOUNTCODEMAPOFFICEID uniqueidentifier
)  
    as
    select 
        NAMEID as VALUE, 
        TYPENAME as LABEL
    from dbo.PDACCOUNTCODEMAPAPPLICATIONTYPE
    where PDACCOUNTCODEMAPOFFICEID = @PDACCOUNTCODEMAPOFFICEID

    union

    select sum(NAMEID) as VALUE,
       max( case rowId when 1 then TYPENAME else '' end ) + ' and ' +
       max( case rowId when 2 then lower(TYPENAME) else '' end ) as LABEL
    from ( select p1.NAMEID, p1.TYPENAME, ROW_NUMBER() over(order by p1.NAMEID)
           from dbo.PDACCOUNTCODEMAPAPPLICATIONTYPE p1 
           where p1.PDACCOUNTCODEMAPOFFICEID = @PDACCOUNTCODEMAPOFFICEID) D ( NAMEID, TYPENAME, rowId )
    order by VALUE