USP_SIMPLEDATALIST_DESIGNATIONREPORTCODE1_FULL

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