USP_MKTSEGMENTATIONEXCLUSIONSELECTION_INSERT

Inserts a new row into the marketing effort exclusion selection table.

Parameters

Parameter	Parameter Type	Mode
@SEGMENTATIONEXCLUSIONID	uniqueidentifier	IN
@IDSETREGISTERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MKTSEGMENTATIONEXCLUSIONSELECTION_INSERT
(
  @SEGMENTATIONEXCLUSIONID uniqueidentifier,
  @IDSETREGISTERID 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();

  --Clear out previous uses of selection due to overwrite

  delete from dbo.[MKTSEGMENTATIONEXCLUSIONSELECTION]
  where [IDSETREGISTERID] = @IDSETREGISTERID;

  insert into dbo.[MKTSEGMENTATIONEXCLUSIONSELECTION] (
    [SEGMENTATIONEXCLUSIONID],
    [IDSETREGISTERID],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED]
  ) values (
    @SEGMENTATIONEXCLUSIONID,
    @IDSETREGISTERID,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE
  );

  return 0;