USP_SIMPLEDATALIST_PDACCOUNTSEGMENTMAPPINGLONGDESCRIPTION

Returns a list of available segment names for an account segment.

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTSTRUCTUREID	uniqueidentifier	IN	PDACCOUNTSTRUCTUREID

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTSEGMENTMAPPINGLONGDESCRIPTION
(@PDACCOUNTSTRUCTUREID uniqueidentifier)
as
    select
        LONGDESCRIPTIONID as VALUE,
        LONGDESCRIPTION as LABEL
    from dbo.PDACCOUNTSEGMENTMAPPING
    where PDACCOUNTSTRUCTUREID = @PDACCOUNTSTRUCTUREID
        and ISDEFAULT = 1

    union all

    select 
        LONGDESCRIPTIONID as VALUE,
        LONGDESCRIPTION as LABEL
    from dbo.PDACCOUNTSEGMENTMAPPINGVIEW
    where PDACCOUNTSTRUCTUREID = @PDACCOUNTSTRUCTUREID
    order by LONGDESCRIPTION