USP_SIMPLEDATALIST_OTHER

CREATE procedure dbo.USP_SIMPLEDATALIST_OTHER as
  select VALUE, LABEL
  from
    (select 
        ID as VALUE, 
        DESCRIPTION as LABEL,
    SEQUENCE
    from dbo.OTHERPAYMENTMETHODCODE
  union all
  select '99999999-9999-9999-9999-999999999999', 'All other subtypes', 0) V1
    order by SEQUENCE