USP_MKTMEMBERSHIPMAILINGACTIVE_LOAD

CREATE procedure dbo.[USP_MKTMEMBERSHIPMAILINGACTIVE_LOAD]
(
  @SEGMENTATIONID uniqueidentifier
)
as
  set nocount on;

  select
    [RENEWALS],
    [UPGRADES],
    [DOWNGRADES],
    [TOTALRENEWALAMOUNT],
    [AVERAGERENEWALAMOUNT],
    [COSTPERRENEWAL],
    [RENEWALRATE],
    [UPGRADERATE],
    [DOWNGRADERATE],
    [ORGANIZATIONTOTALRENEWALAMOUNT],
    [ORGANIZATIONAVERAGERENEWALAMOUNT],
    [ORGANIZATIONCOSTPERRENEWAL]
  from dbo.[MKTMEMBERSHIPMAILINGACTIVE]
  where [ID] = @SEGMENTATIONID;

  return 0;