USP_DUPLICATESEARCH_MKTSEGMENTSPONSORSHIP

This provides the ability to search for duplicates of a sponsorship 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_MKTSEGMENTSPONSORSHIP]
(
  @ID uniqueidentifier = null,
  @CODE nvarchar(10) = null,
  @SELECTIONS xml,
  @MAXROWS smallint = 100
)
as
  set nocount on;

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

  return 0;