USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTSOURCECODE

Parameters

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

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTSOURCECODE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @SOURCECODEID uniqueidentifier = null output,
  @SOURCECODELOCKED bit = null output,
  @ITEMLIST xml = null output,
  @ACTIVE bit = null output,
  @CODE nvarchar(10) = null output,
  @CODEVALUEID uniqueidentifier = null output
)
as

  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @TSLONG = [MKTSEGMENTATION].[TSLONG],
    @ACTIVE = [MKTSEGMENTATION].[ACTIVE],
    @ITEMLIST = dbo.[UFN_MKTSOURCECODEPART_GETITEMLIST2_TOITEMLISTXML]([MKTSEGMENTATION].[ID]),
    @CODE = [MKTSEGMENTATION].[CODE],
    @CODEVALUEID = [MKTSEGMENTATION].[PARTDEFINITIONVALUESID],
    @SOURCECODEID = [MKTSEGMENTATION].[SOURCECODEID],
    @SOURCECODELOCKED = isnull([MKTCOMMUNICATIONTEMPLATEDEFAULT].[SOURCECODELOCKED], 0)
  from 
    dbo.[MKTSEGMENTATION]
    left join dbo.[MKTCOMMUNICATIONTEMPLATE] on [MKTSEGMENTATION].[ID] = [MKTCOMMUNICATIONTEMPLATE].[MKTSEGMENTATIONID]
    left join dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] on [MKTCOMMUNICATIONTEMPLATE].[ID] = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[COMMUNICATIONTEMPLATEID]

  where
    [MKTSEGMENTATION].[ID] = @ID;

  return 0;