USP_SIMPLEDATALIST_PDCOMPOSITESEGMENTMAPPING
Returns simple data list for a specified table.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PDACCOUNTTABLESAVAILABLEFORSEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_PDCOMPOSITESEGMENTMAPPING(
@PDACCOUNTTABLESAVAILABLEFORSEGMENTID uniqueidentifier
) as
select
LONGDESCRIPTIONID as VALUE,
LONGDESCRIPTION as LABEL
from dbo.PDCOMPOSITESEGMENTMAPPINGVIEW
where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = @PDACCOUNTTABLESAVAILABLEFORSEGMENTID
order by LONGDESCRIPTION