USP_DUPLICATESEARCH_MKTSEGMENTREVENUE
This provides the ability to search for duplicates of a revenue 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_MKTSEGMENTREVENUE]
(
@ID uniqueidentifier = null,
@CODE nvarchar(10) = null,
@SELECTIONS xml,
@MAXROWS smallint = 100
)
as
set nocount on;
exec dbo.[USP_MKTSEGMENT_FINDDUPLICATES]
@ID = @ID,
@SEGMENTTYPECODE = 3,
@CODE = @CODE,
@SELECTIONS = @SELECTIONS,
@MAXROWS = @MAXROWS;
return 0;