USP_DUPLICATESEARCH_MKTSEGMENTLIST
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 |
| @LISTID | uniqueidentifier | IN | List ID |
| @MAXROWS | smallint | IN | Input parameter indicating the maximum number of rows to return. |
Definition
Copy
CREATE procedure dbo.[USP_DUPLICATESEARCH_MKTSEGMENTLIST]
(
@ID uniqueidentifier = null,
@CODE nvarchar(10) = null,
@LISTID uniqueidentifier = null,
@MAXROWS smallint = 100
)
as
set nocount on;
exec dbo.[USP_MKTSEGMENT_FINDDUPLICATES]
@ID = @ID,
@SEGMENTTYPECODE = 2,
@CODE = @CODE,
@LISTID = @LISTID,
@MAXROWS = @MAXROWS;
return 0;