USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTLIST_EXPRESSION
The load procedure used by the view dataform template "List Segment Expression View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @SEGMENTLISTIMPORTPROCESSID | uniqueidentifier | INOUT | List segment import process ID |
| @ISCHILDLISTSEGMENT | bit | INOUT | Is child list segment |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTLIST_EXPRESSION
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@SEGMENTLISTIMPORTPROCESSID uniqueidentifier = null output,
@ISCHILDLISTSEGMENT bit = null output
)
as
set nocount on;
set @DATALOADED = 0;
select
@DATALOADED = 1,
@SEGMENTLISTIMPORTPROCESSID = [MKTSEGMENTLISTIMPORTPROCESS].[ID],
@ISCHILDLISTSEGMENT = (case when [MKTSEGMENTLIST].[PARENTSEGMENTID] is null then 0 else 1 end)
from dbo.[MKTSEGMENT]
inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
left join dbo.[MKTSEGMENTLISTIMPORTPROCESS] on [MKTSEGMENTLISTIMPORTPROCESS].[SEGMENTLISTID] = [MKTSEGMENTLIST].[ID]
where [MKTSEGMENT].[ID] = @ID;
return 0;