USP_MKTSEGMENTLISTDEDUPEPROCESS_GETOPTIONS
Retrieves the options for a list segment deduplication process parameter set.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.[USP_MKTSEGMENTLISTDEDUPEPROCESS_GETOPTIONS]
(
@ID uniqueidentifier
)
as
set nocount on;
select
[MKTSEGMENTLIST].[SEGMENTID]
from dbo.[MKTSEGMENTLISTDEDUPEPROCESS]
inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENTLISTDEDUPEPROCESS].[SEGMENTLISTID]
where [MKTSEGMENTLISTDEDUPEPROCESS].[ID] = @ID;
return 0;