USP_SIMPLEDATALIST_MKTSOURCECODEPARTDEFINITIONVALUEDELIMITERS
Returns a list of source code part definition value IDs for a given source code, along with their delimiters.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SOURCECODEID | uniqueidentifier | IN | Source code ID |
Definition
Copy
CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTSOURCECODEPARTDEFINITIONVALUEDELIMITERS]
(
@SOURCECODEID uniqueidentifier = null
)
as
select
[MKTSOURCECODEPARTDEFINITIONVALUES].[ID] as [VALUE],
isnull([MKTSOURCECODEPARTDEFINITIONVALUES].[DELIM], '') as [LABEL]
from dbo.[MKTSOURCECODEITEM]
inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEITEM].[MKTSOURCECODEPARTDEFINITIONID]
inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID] = [MKTSOURCECODEPARTDEFINITION].[ID]
where [MKTSOURCECODEITEM].[SOURCECODEID] = @SOURCECODEID;