USP_APPEALMAILING_GETCHANNELOFFERCOUNTS
Retrieves offer counts by channel for the given run of the segmentation activate process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MKTSEGMENTATIONACTIVATEPROCESSSTATUSID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_APPEALMAILING_GETCHANNELOFFERCOUNTS
(
@MKTSEGMENTATIONACTIVATEPROCESSSTATUSID uniqueidentifier
)
as
select
CHANNEL,
OFFERCOUNT
from
APPEALMAILINGACTIVATEPROCESSOFFERCOUNT
where
MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = @MKTSEGMENTATIONACTIVATEPROCESSSTATUSID