USP_SIMPLEDATALIST_PDACCOUNTCODEMAPPLEDGE

CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPPLEDGE as
    select VALUE, LABEL
  from
  (select 
        ID as VALUE, 
        NAME as LABEL,
    2 as SEQUENCE
    from dbo.PLEDGESUBTYPE
  union all
  select '99999999-9999-9999-9999-999999999999', 'All pledge subtypes', 0
  union all
  select '818F7494-C0BC-44E8-AAD6-58DC81162D80', '<Not used>', 1) V1
  order by SEQUENCE, LABEL