USP_DUPLICATESEARCH_MKTSEGMENTATIONSEGMENT

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

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN	Segment ID
@CODE	nvarchar(10)	IN	Code
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.[USP_DUPLICATESEARCH_MKTSEGMENTATIONSEGMENT]
(
  @SEGMENTID uniqueidentifier = null,
  @CODE nvarchar(10) = null,
  @MAXROWS smallint = 100
)
as
  set nocount on;

  declare @SEGMENTTYPECODE tinyint;
  declare @LISTID uniqueidentifier;

  select
    @SEGMENTTYPECODE = [SEGMENTTYPECODE]
  from dbo.[MKTSEGMENT]
  where [ID] = @SEGMENTID;

  if @SEGMENTTYPECODE = 2
    select
      @LISTID = [MKTSEGMENTLIST].[LISTID]
    from dbo.[MKTSEGMENT]
    inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
    where [MKTSEGMENT].[ID] = @SEGMENTID;

  exec dbo.[USP_MKTSEGMENT_FINDDUPLICATES]
    @ID = @SEGMENTID,
    @SEGMENTTYPECODE = @SEGMENTTYPECODE,
    @CODE = @CODE,
    @LISTID = @LISTID,
    @MAXROWS = @MAXROWS;

  return 0;