UFN_MKTSEGMENTATIONPASSIVEPACKAGE_GETRESPONSECOUNT
Returns the number of responses expected from a package used in a public media marketing effort.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PACKAGEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTSEGMENTATIONPASSIVEPACKAGE_GETRESPONSECOUNT]
(
@PACKAGEID uniqueidentifier
)
returns integer
as
begin
declare @RESPONSES integer;
select
@RESPONSES = sum(dbo.[UFN_MKTSEGMENTATIONPASSIVESEGMENT_GETRESPONSECOUNT]([MKTSEGMENTATIONSEGMENT].[ID], [MKTSEGMENTPASSIVE].[IMPRESSIONCALCULATIONMETHODCODE], [MKTSEGMENTPASSIVE].[IMPRESSIONS], [MKTSEGMENTATIONSEGMENT].[EXPOSURESTARTDATE], [MKTSEGMENTATIONSEGMENT].[EXPOSUREENDDATE], [MKTSEGMENTATIONSEGMENT].[RESPONSERATE]))
from dbo.[MKTSEGMENTATIONSEGMENT]
inner join dbo.[MKTSEGMENTPASSIVE] on [MKTSEGMENTPASSIVE].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
where [MKTSEGMENTATIONSEGMENT].[PACKAGEID] = @PACKAGEID;
return @RESPONSES;
end