USP_MKTUPDATEMAILINGCOUNTSPROCESS_ADDEDIT

Updates/Adds the parameters for a marketing effort's remove members process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@SEGMENTATIONID	uniqueidentifier	IN
@FILENAME	nvarchar(250)	IN
@SELECTIONNAME	nvarchar(250)	IN
@HASSELECTION	bit	IN
@OVERWRITE	bit	IN
@FIRSTROWCONTAINSFIELDNAMES	bit	IN
@FINDERNUMBERCOLUMN	int	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTUPDATEMAILINGCOUNTSPROCESS_ADDEDIT]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @SEGMENTATIONID uniqueidentifier,
  @FILENAME nvarchar(250),
  @SELECTIONNAME nvarchar(250) = null,
  @HASSELECTION bit = 0,
  @OVERWRITE bit = 0,
  @FIRSTROWCONTAINSFIELDNAMES bit = 0,
  @FINDERNUMBERCOLUMN int
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();

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

  if exists(select * from dbo.[MKTUPDATEMAILINGCOUNTSPROCESS] where [SEGMENTATIONID] = @SEGMENTATIONID)
    begin
      update dbo.[MKTUPDATEMAILINGCOUNTSPROCESS] set
        [FILENAME] = @FILENAME,
        [FIRSTROWCONTAINSFIELDNAMES] = @FIRSTROWCONTAINSFIELDNAMES,
        [FINDERNUMBERCOLUMN] = @FINDERNUMBERCOLUMN,
        [SELECTIONNAME] = @SELECTIONNAME,
        [HASSELECTION] = @HASSELECTION,
        [OVERWRITE] = @OVERWRITE,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE
      where [SEGMENTATIONID] = @SEGMENTATIONID;
    end
  else
    begin
      insert into dbo.[MKTUPDATEMAILINGCOUNTSPROCESS] (
        [SEGMENTATIONID],
        [FILENAME],
        [FIRSTROWCONTAINSFIELDNAMES],
        [FINDERNUMBERCOLUMN],
        [SELECTIONNAME],
        [HASSELECTION],
        [OVERWRITE],
        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED]
      ) values (
        @SEGMENTATIONID,
        @FILENAME,
        @FIRSTROWCONTAINSFIELDNAMES,
        @FINDERNUMBERCOLUMN,
        @SELECTIONNAME,
        @HASSELECTION,
        @OVERWRITE,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
      );
    end

  select
    @ID = [ID]
  from dbo.[MKTUPDATEMAILINGCOUNTSPROCESS]
  where [SEGMENTATIONID] = @SEGMENTATIONID;

  return 0;