USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONEFFORTSOURCECODEPARTS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@SOURCECODEID	uniqueidentifier	INOUT
@SOURCECODELOCKED	bit	INOUT
@ITEMLIST	xml	INOUT
@CODE	nvarchar(10)	INOUT
@CODEVALUEID	uniqueidentifier	INOUT
@SHOWLOCKEDFIELDS	bit	INOUT
@ACTIVE	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONEFFORTSOURCECODEPARTS
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @CURRENTAPPUSERID uniqueidentifier,
  @SOURCECODEID uniqueidentifier = null output,
  @SOURCECODELOCKED bit = null output,
  @ITEMLIST xml = null output,
  @CODE nvarchar(10) = null output,
  @CODEVALUEID uniqueidentifier = null output,
  @SHOWLOCKEDFIELDS bit = null output,
  @ACTIVE bit = null output
)
as
  set nocount on;

  -- be sure to set this, in case the select returns no rows
  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @SOURCECODEID = [MKTSEGMENTATION].[SOURCECODEID],
    @SOURCECODELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[SOURCECODELOCKED],
    @ITEMLIST = dbo.[UFN_MKTSOURCECODEPART_GETITEMLIST2_TOITEMLISTXML]([MKTSEGMENTATION].[ID]),
    @CODE = [MKTSEGMENTATION].[CODE],
    @CODEVALUEID = [MKTSEGMENTATION].[PARTDEFINITIONVALUESID],
    @SHOWLOCKEDFIELDS = isnull([MKTCOMMUNICATIONEFFORTUSERSETTINGS].[SHOWLOCKEDFIELDS], 0),
    @ACTIVE = [MKTSEGMENTATION].[ACTIVE]
  from 
    dbo.[MKTSEGMENTATION]
    left join dbo.[MKTCOMMUNICATIONEFFORTUSERSETTINGS] on [MKTSEGMENTATION].[ID] = [MKTCOMMUNICATIONEFFORTUSERSETTINGS].[SEGMENTATIONID] and [MKTCOMMUNICATIONEFFORTUSERSETTINGS].[APPUSERID] = @CURRENTAPPUSERID
    left join dbo.[MKTCOMMUNICATIONTEMPLATE] on [MKTSEGMENTATION].[ID] = [MKTCOMMUNICATIONTEMPLATE].[MKTSEGMENTATIONID]
    left join dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] on [MKTCOMMUNICATIONTEMPLATE].[ID] = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[COMMUNICATIONTEMPLATEID]
  where
    [MKTSEGMENTATION].[ID] = @ID;

  return 0;