USP_SIMPLEDATALIST_CODETABLECATEGORY

CREATE procedure dbo.USP_SIMPLEDATALIST_CODETABLECATEGORY 
as
    select distinct
        CODETABLECATEGORY.ID as VALUE, 
        DESCRIPTION AS LABEL
    from 
        dbo.CODETABLECATEGORY
    join 
        dbo.V_INSTALLED_CODETABLECATALOG CT on CODETABLECATEGORY.ID = CT.CATEGORYID
    order by DESCRIPTION