USP_SIMPLEDATALIST_PDACCOUNTCODEMAPBENEFITS

CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPBENEFITS as
  select VALUE, LABEL
  from
    (select 
        ID as VALUE, 
        NAME as LABEL,
    1 as SEQUENCE
    from dbo.BENEFIT
  union all
  select '99999999-9999-9999-9999-999999999999', 'All benefit subtypes', 0) V1
    order by SEQUENCE, LABEL