USP_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_SWAPRULES

Swaps the sequence of two marketing acknowledgement template rules.

Parameters

Parameter	Parameter Type	Mode
@TOPRULEID	uniqueidentifier	IN
@BOTTOMRULEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_SWAPRULES]
(
  @TOPRULEID uniqueidentifier,
  @BOTTOMRULEID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

  if @CHANGEAGENTID is null  
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

  set @CURRENTDATE = getdate();

  /* Swap the sequences */
  update dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE] set
    [SEQUENCE] = [SEQUENCE] + 1,
    [CHANGEDBYID] = @CHANGEAGENTID,
    [DATECHANGED] = @CURRENTDATE
  where [ID] = @TOPRULEID;

  update dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE] set
    [SEQUENCE] = [SEQUENCE] - 1,
    [CHANGEDBYID] = @CHANGEAGENTID,
    [DATECHANGED] = @CURRENTDATE
  where [ID] = @BOTTOMRULEID;

  return 0;