USP_DUPLICATESEARCH_MKTSEGMENTATIONPASSIVESEGMENT_2

This provides the ability to search for duplicates of a marketing effort public media segment.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	ID
@SOURCECODE	nvarchar(50)	IN	Source code
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.[USP_DUPLICATESEARCH_MKTSEGMENTATIONPASSIVESEGMENT_2]
(
  @ID uniqueidentifier = null,
  @SOURCECODE nvarchar(50),
  @MAXROWS smallint = 100
)
as
  set nocount on;

  declare @SOURCECODES table ([ID] uniqueidentifier, [SOURCECODE] nvarchar(50), [SEGMENTNAME] nvarchar(100), [SEGMENTTYPE] nvarchar(100), [MAILINGNAME] nvarchar(100));

  insert into @SOURCECODES
  select top (@MAXROWS)
    [MKTSEGMENTATIONSEGMENT].[ID],
    dbo.[UFN_MKTSOURCECODE_BUILDCODE]([MKTSEGMENTATIONSEGMENT].[ID], default, default),
    [MKTSEGMENT].[NAME] as [SEGMENTNAME],
    [MKTSEGMENT].[SEGMENTTYPE],
    [MKTSEGMENTATION].[NAME] as [MAILINGNAME]
  from dbo.[MKTSEGMENTATIONSEGMENT]
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
  where (@ID is null or [MKTSEGMENTATIONSEGMENT].[ID] <> @ID);

  select * from @SOURCECODES where [SOURCECODE] = @SOURCECODE;

  return 0;