USP_MKTSPONSORSHIPMAILINGTEMPLATE_SWAPRULES

Swaps the sequence of two sponsorship effort template rules.

Parameters

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

Definition

Copy



create procedure dbo.[USP_MKTSPONSORSHIPMAILINGTEMPLATE_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();

  update 
    dbo.[MKTSPONSORSHIPMAILINGTEMPLATERULE] 
  set
    [SEQUENCE] = [SEQUENCE] + 1,
    [CHANGEDBYID] = @CHANGEAGENTID,
    [DATECHANGED] = @CURRENTDATE
  where 
    [ID] = @TOPRULEID;

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

  return 0;