USP_SIMPLEDATALIST_PDACCOUNTCODEMAPRESOURCECATEGORY

            CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPRESOURCECATEGORY as
                select VALUE, LABEL
                from
                    ((select 
                        ID as VALUE, 
                        DESCRIPTION as LABEL,
                        SEQUENCE as SEQUENCE
                        from dbo.RESOURCECATEGORYCODE)
                    union all
                    (select '99999999-9999-9999-9999-999999999999', 'All resource categories', 0)) V1
                order by SEQUENCE, LABEL