USP_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_LOAD

Loads the activated membership renewal effort segment or test segment calculations.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN
@TESTSEGMENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTMEMBERSHIPMAILINGSEGMENTACTIVE_LOAD]
(
  @SEGMENTID uniqueidentifier,
  @TESTSEGMENTID uniqueidentifier = null
)
as
  set nocount on;

  select
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[RENEWALS],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[UPGRADES],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[DOWNGRADES],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[TOTALRENEWALAMOUNT],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[AVERAGERENEWALAMOUNT],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[COSTPERRENEWAL],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[RENEWALRATE],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[UPGRADERATE],
    [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[DOWNGRADERATE]
  from dbo.[MKTMEMBERSHIPMAILINGSEGMENTACTIVE]
  inner join dbo.[MKTSEGMENTATIONSEGMENTACTIVE] on [MKTSEGMENTATIONSEGMENTACTIVE].[ID] = [MKTMEMBERSHIPMAILINGSEGMENTACTIVE].[ID]
  where [MKTSEGMENTATIONSEGMENTACTIVE].[SEGMENTID] = @SEGMENTID
  and ((@TESTSEGMENTID is null and [MKTSEGMENTATIONSEGMENTACTIVE].[TESTSEGMENTID] is null) or (@TESTSEGMENTID is not null and [MKTSEGMENTATIONSEGMENTACTIVE].[TESTSEGMENTID] = @TESTSEGMENTID));

  return 0;