USP_SIMPLEDATALIST_CREDITCARD

CREATE procedure dbo.USP_SIMPLEDATALIST_CREDITCARD as
  select VALUE, LABEL
  from
    (select 
        ID as VALUE, 
        DESCRIPTION as LABEL,
    SEQUENCE
    from dbo.CREDITTYPECODE
  union all
  select '99999999-9999-9999-9999-999999999999', 'All credit cards', 0) V1
    order by SEQUENCE