USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTSEGMENTATIONCONTEXT

The load procedure used by the view dataform template "Segment (Marketing Effort Context) View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(72)	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.
@NAME	nvarchar(100)	INOUT	Name
@QUERYVIEWCATALOGID	uniqueidentifier	INOUT	Record source ID
@CODE	nvarchar(10)	INOUT	Code
@CODEVALUEID	uniqueidentifier	INOUT	Code value ID
@ISCONSOLIDATED	bit	INOUT	Is consolidated?
@LISTCODE	nvarchar(10)	INOUT	List code
@LISTCODEVALUEID	uniqueidentifier	INOUT	List code value ID
@DATECHANGED	datetime	INOUT	Date changed
@PARENTLISTID	uniqueidentifier	INOUT
@PARENTLIST	nvarchar(50)	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTSEGMENTATIONCONTEXT]
(
  @ID nvarchar(72),
  @DATALOADED bit = 0 output,
  @NAME nvarchar(100) = null output,
  @QUERYVIEWCATALOGID uniqueidentifier = null output,
  @CODE nvarchar(10) = null output,
  @CODEVALUEID uniqueidentifier = null output,
  @ISCONSOLIDATED bit = null output,
  @LISTCODE nvarchar(10) = null output,
  @LISTCODEVALUEID uniqueidentifier = null output,  
  @DATECHANGED datetime = null output,
  @PARENTLISTID uniqueidentifier = null output,
  @PARENTLIST nvarchar(50) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @NAME = [MKTSEGMENT].[NAME],
    @QUERYVIEWCATALOGID = [MKTSEGMENT].[QUERYVIEWCATALOGID],
    @CODE = [MKTSEGMENT].[CODE],
    @CODEVALUEID = [MKTSEGMENT].[PARTDEFINITIONVALUESID],
    @ISCONSOLIDATED = (case when [MKTSEGMENTLIST].[CONSOLIDATEDQUERYVIEWID] is null then 0 else 1 end),    
    @LISTCODE = case when [MKTSEGMENTLIST].[ID] is null then isnull([MKTRECORDSOURCE].[CODE], '') else isnull([MKTLIST].[CODE], '') end,
    @LISTCODEVALUEID = case when [MKTSEGMENTLIST].[ID] is null then [MKTRECORDSOURCE].[PARTDEFINITIONVALUESID] else [MKTLIST].[PARTDEFINITIONVALUESID] end,
    @DATECHANGED = [MKTSEGMENT].[DATECHANGED],
    @PARENTLISTID = [MKTSEGMENTLIST].[LISTID],
    @PARENTLIST = [MKTLIST].[NAME]
  from dbo.[MKTSEGMENT]
  left outer join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
  left outer join dbo.[MKTLIST] on [MKTLIST].[ID] = [MKTSEGMENTLIST].[LISTID]
  left outer join dbo.[MKTRECORDSOURCE] on [MKTRECORDSOURCE].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
  where [MKTSEGMENT].[ID] = convert(uniqueidentifier, left(@ID, 36));

  return 0;