USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTLISTDEDUPEPROCESS

The load procedure used by the view dataform template "List Segment Deduplication Process 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.
@SEGMENTNAME	nvarchar(100)	INOUT	Segment
@SEGMENTDESCRIPTION	nvarchar(255)	INOUT	Description
@SEGMENTCODE	nvarchar(10)	INOUT	Code
@SEGMENTID	uniqueidentifier	INOUT	Segment ID
@LISTID	uniqueidentifier	INOUT	List ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTLISTDEDUPEPROCESS]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTNAME nvarchar(100) = null output,
  @SEGMENTDESCRIPTION nvarchar(255) = null output,
  @SEGMENTCODE nvarchar(10) = null output,
  @SEGMENTID uniqueidentifier = null output,
  @LISTID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  with [SEGMENTLIST] ([SEGMENTID], [LISTID]) as
  (
    select
      [MKTSEGMENTLIST].[SEGMENTID],
      [MKTSEGMENTLIST].[LISTID]
    from dbo.[MKTSEGMENTLISTDEDUPEPROCESS]
    inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENTLISTDEDUPEPROCESS].[SEGMENTLISTID]
    where [MKTSEGMENTLISTDEDUPEPROCESS].[ID] = @ID
  )
  select
    @DATALOADED = 1,
    @SEGMENTNAME = [MKTSEGMENT].[NAME],
    @SEGMENTDESCRIPTION = [MKTSEGMENT].[DESCRIPTION],
    @SEGMENTCODE = [MKTSEGMENT].[CODE],
    @SEGMENTID = [MKTSEGMENT].[ID],
    @LISTID = [SEGMENTLIST].[LISTID]
  from [SEGMENTLIST]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [SEGMENTLIST].[SEGMENTID];

  return 0;