USP_SIMPLEDATALIST_PDACCOUNTCODEVALUES2

CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEVALUES2 (@PDACCOUNTSYSTEMID uniqueidentifier)
as
    select
        PDACCOUNTSEGMENTVALUE.ID as VALUE,
        SHORTDESCRIPTION as LABEL
    from dbo.PDACCOUNTSEGMENTVALUE
    inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSTRUCTURE.ID = PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID
    where
        PDACCOUNTSTRUCTURE.SEGMENTTYPE = 1
        and PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
    order by SHORTDESCRIPTION