USP_SIMPLEDATALIST_DESIGNATIONREPORTCODE_FULL

create procedure dbo.USP_SIMPLEDATALIST_DESIGNATIONREPORTCODE_FULL as
    select 
    [DESCRIPTION] as VALUE, 
    [DESCRIPTION] as LABEL
from dbo.DESIGNATIONREPORT1CODE
union
select 
    [DESCRIPTION] as VALUE, 
    [DESCRIPTION] as LABEL
from dbo.DESIGNATIONREPORT2CODE
order by [DESCRIPTION]