USP_MKTSEGMENTATIONEXCLUSION_DELETEFROMSEGMENTATIONDATA

Remove people from the segmentation data table.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONEXCLUSIONID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MKTSEGMENTATIONEXCLUSION_DELETEFROMSEGMENTATIONDATA
(
    @SEGMENTATIONEXCLUSIONID uniqueidentifier
)
as
  set nocount on;

  declare @SEGMENTATIONID uniqueidentifier;
  declare @DATATABLE nvarchar(128);
  declare @EXCLUSIONTABLE nvarchar(128);

  select @SEGMENTATIONID = [SEGMENTATIONID] from dbo.[MKTSEGMENTATIONEXCLUSION] where [MKTSEGMENTATIONEXCLUSION].[ID] = @SEGMENTATIONEXCLUSIONID;
  set @DATATABLE = dbo.[UFN_MKTSEGMENTATIONACTIVATE_MAKETABLENAME](@SEGMENTATIONID);
  set @EXCLUSIONTABLE = dbo.[UFN_MKTSEGMENTATIONACTIVATEEXCLUSION_MAKETABLENAME](@SEGMENTATIONID);

  declare @SQL nvarchar(4000);

  set @SQL = 'delete from dbo.[' + @DATATABLE + ']' + char(13) +
             '  from dbo.[' + @DATATABLE + '] [DATA]' + char(13) +
             '  inner join dbo.[' + @EXCLUSIONTABLE + '] [EXCL]' + char(13) +
             '  on [DATA].[FINDERNUMBER] = [EXCL].[FINDERNUMBER]' + char(13) +
             '  where [EXCL].[SEGMENTATIONEXCLUSIONID] = @SEGMENTATIONEXCLUSIONID';

  exec sp_executesql @SQL, N'@SEGMENTATIONEXCLUSIONID uniqueidentifier', @SEGMENTATIONEXCLUSIONID = @SEGMENTATIONEXCLUSIONID;

  return 0;