USP_DUPLICATESEARCH_MKTSPONSORSHIPMAILINGTEMPLATERULE
This provides the ability to search for duplicates of a sponsorship effort template rule's sponsorship 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_MKTSPONSORSHIPMAILINGTEMPLATERULE]
(
@SEGMENTID uniqueidentifier = null,
@CODE nvarchar(10) = null,
@MAXROWS smallint = 100
)
as
set nocount on;
exec dbo.[USP_MKTSEGMENT_FINDDUPLICATES]
@ID = @SEGMENTID,
@SEGMENTTYPECODE = 5,
@CODE = @CODE,
@MAXROWS = @MAXROWS;
return 0;