USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTGROUPREFRESH

The load procedure used by the view dataform template "Segment Group Refresh 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.
@SEGMENTGROUPID	uniqueidentifier	INOUT	Segment group ID
@SEGMENTGROUPNAME	nvarchar(100)	INOUT	Group
@SEGMENTFAMILYTYPECODE	tinyint	INOUT	Type code
@SEGMENTS	nvarchar(max)	INOUT	Segments

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTGROUPREFRESH]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTGROUPID uniqueidentifier = null output,
  @SEGMENTGROUPNAME nvarchar(100) = null output,
  @SEGMENTFAMILYTYPECODE tinyint = null output,
  @SEGMENTS nvarchar(max) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @SEGMENTGROUPID = [MKTSEGMENTGROUP].[ID],
    @SEGMENTGROUPNAME = [MKTSEGMENTGROUP].[NAME],
    @SEGMENTFAMILYTYPECODE = [MKTSEGMENTGROUP].[SEGMENTFAMILYTYPECODE],
    @SEGMENTS = (select stuff((select ', ' + [MKTSEGMENT].[NAME]
                               from dbo.[MKTGROUPSEGMENTS]
                               inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTGROUPSEGMENTS].[SEGMENTID]
                               where [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = [MKTSEGMENTGROUP].[ID]
                               for xml path(''), type
                               ).value('.', 'varchar(max)')
                               , 1, 2, ''))
  from dbo.[MKTSEGMENTGROUPREFRESHPROCESS]
  inner join dbo.[MKTSEGMENTGROUP] on [MKTSEGMENTGROUP].[ID] = [MKTSEGMENTGROUPREFRESHPROCESS].[SEGMENTGROUPID]
  where [MKTSEGMENTGROUPREFRESHPROCESS].[ID] = @ID;

  return 0;