USP_DATALIST_MKTAPPEALMAILINGPROCESSES
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN | |
| @SEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_DATALIST_MKTAPPEALMAILINGPROCESSES]
(
@SEGMENTATIONID uniqueidentifier = null,
@SEGMENTID uniqueidentifier = null
)
as
set nocount on;
select
dbo.[UFN_MKTSEGMENTATIONSEGMENT_ISRECORDCOUNTCACHECURRENT](@SEGMENTID, 1) [ISRECORDCOUNTCACHECURRENT],
(select [ID] from dbo.[MKTSEGMENTATIONACTIVATEPROCESS] where [SEGMENTATIONID] = @SEGMENTATIONID) [SEGMENTATIONACTIVATEPROCESSID],
(select [ID] from dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] where [SEGMENTATIONID] = @SEGMENTATIONID) [SEGMENTATIONSEGMENTCALCULATEPROCESSID],
(select [MKTSEGMENTATIONSEGMENTID] from dbo.[APPEALMAILING] where [ID] = @SEGMENTATIONID) [SEGMENTATIONSEGMENTID];
return 0;