UFN_MKTSEGMENTATIONPACKAGEACTIVE_GETRESPONSECOUNT

Returns the total number of responses received for segments and test segments using a particular package in an activated marketing effort.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN
@PACKAGEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSEGMENTATIONPACKAGEACTIVE_GETRESPONSECOUNT]
(
  @SEGMENTATIONID uniqueidentifier,
  @PACKAGEID uniqueidentifier
)
returns integer
as
begin
  declare @RESPONSES integer;

  select @RESPONSES = isnull(sum([RESPONSES]), 0)
  from dbo.[MKTSEGMENTATIONSEGMENTACTIVE]
  inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENTACTIVE].[SEGMENTID]
  where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
  and [MKTSEGMENTATIONSEGMENTACTIVE].[TESTSEGMENTID] is null
  and [MKTSEGMENTATIONSEGMENT].[PACKAGEID] = @PACKAGEID;

  select @RESPONSES = @RESPONSES + isnull(sum([RESPONSES]), 0)
  from dbo.[MKTSEGMENTATIONSEGMENTACTIVE]
  inner join dbo.[MKTSEGMENTATIONTESTSEGMENT] on [MKTSEGMENTATIONTESTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENTACTIVE].[TESTSEGMENTID]
  inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID]
  where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
  and [MKTSEGMENTATIONTESTSEGMENT].[PACKAGEID] = @PACKAGEID;

  return @RESPONSES;
end