USP_SIMPLEDATALIST_GIFTINKIND

CREATE procedure dbo.USP_SIMPLEDATALIST_GIFTINKIND as
  select VALUE, LABEL
  from
  (select 
        ID as VALUE, 
        DESCRIPTION as LABEL,
    SEQUENCE
    from dbo.GIFTINKINDSUBTYPECODE
  union all
  select '99999999-9999-9999-9999-999999999999', 'All gift-in-kind subtypes', 0) V1
    order by SEQUENCE