USP_DUPLICATESEARCH_MKTSEGMENTLISTBYSELECTION

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

Parameters

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

Definition

Copy



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

  declare @LISTID uniqueidentifier;

  if @ID is null
    --For the add form...

    select distinct
      @LISTID = [MKTSEGMENTLIST].[LISTID]
    from dbo.[IDSETREGISTER]
    inner join dbo.[UFN_MKTSEGMENT_GETSELECTIONS_FROMITEMLISTXML](@SELECTIONS) as [SELECTIONS] on [SELECTIONS].[SELECTIONID] = [IDSETREGISTER].[ID]
    inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[IDSETRECORDTYPEID] = [IDSETREGISTER].[RECORDTYPEID];
  else
    --For the edit form...

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

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

  return 0;