USP_SIMPLEDATALIST_PDACCOUNTCODEVALUES

CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEVALUES 
as
    select         
    PDACCOUNTSEGMENTVALUE.ID as VALUE, 
        SHORTDESCRIPTION as LABEL
        from dbo.PDACCOUNTSEGMENTVALUE 
        join dbo.PDACCOUNTSTRUCTURE on  PDACCOUNTSTRUCTURE.ID = PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID
        -- inner join dbo.PDCATEGORYDEFINITION on convert(int,PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION) between convert(int,PDCATEGORYDEFINITION.FROMCODE) and convert(int,PDCATEGORYDEFINITION.TOCODE)

        where PDACCOUNTSTRUCTURE.SEGMENTTYPE = 1
        and PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
        order by SHORTDESCRIPTION