USP_SIMPLEDATALIST_PDACCOUNTCODEMAPPLEDGEREASONCODE

CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPPLEDGEREASONCODE as
    select VALUE, LABEL
    from
    (
        select
            ID as VALUE, 
            CODE + ' - ' + DESCRIPTION  as LABEL,
            2 as SEQUENCE
        from dbo.WRITEOFFREASONCODE

        union all
        select '99999999-9999-9999-9999-999999999999', 'All reason codes', 0
    ) V1
    order by SEQUENCE, LABEL