USP_SIMPLEDATALIST_DESIGNATIONREPORTCODE2_FULL

CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATIONREPORTCODE2_FULL as
    select 
    [DESCRIPTION] as VALUE, 
    [DESCRIPTION] as LABEL
from dbo.DESIGNATIONREPORT2CODE
order by [DESCRIPTION]