USP_MKTSEGMENTATIONACTIVE_LOAD

Loads the activated marketing effort calculations.
Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN
Definition

Copy


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

  select
    [QUANTITY],
    [RESPONDERS],
    [RESPONSES],
    [VARIABLECOST],
    [TOTALCOST],
    [COSTPERDOLLARRAISED],
    [TOTALGIFTAMOUNT],
    [AVERAGEGIFTAMOUNT],
    [RESPONSERATE],
    [ROIAMOUNT],
    [ROIPERCENT],
    [EXPECTEDCOSTPERDOLLARRAISED],
    [EXPECTEDRESPONDERS],
    [EXPECTEDTOTALGIFTAMOUNT],
    [EXPECTEDAVERAGEGIFTAMOUNT],
    [EXPECTEDRESPONSERATE],
    [EXPECTEDROIAMOUNT],
    [EXPECTEDROIPERCENT],
    [INDIRECTRESPONDERS],
    [INDIRECTRESPONSES],
    [INDIRECTTOTALGIFTAMOUNT],
    [INDIRECTAVERAGEGIFTAMOUNT],
    [UNRESOLVEDRESPONDERS],
    [UNRESOLVEDRESPONSES],
    [UNRESOLVEDTOTALGIFTAMOUNT],
    [UNRESOLVEDAVERAGEGIFTAMOUNT],
    [ORGANIZATIONVARIABLECOST],
    [ORGANIZATIONTOTALCOST],
    [ORGANIZATIONCOSTPERDOLLARRAISED],
    [ORGANIZATIONTOTALGIFTAMOUNT],
    [ORGANIZATIONAVERAGEGIFTAMOUNT],
    [ORGANIZATIONROIAMOUNT],
    [ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED],
    [ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT],
    [ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT],
    [ORGANIZATIONEXPECTEDROIAMOUNT],
    [ORGANIZATIONINDIRECTTOTALGIFTAMOUNT],
    [ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT],
    [ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT],
    [ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT],
    [COSTTOACQUIRE],
    [COSTPERTHOUSAND],
    [NETPERTHOUSAND],
    [GROSSPERTHOUSAND],
    [ORGANIZATIONCOSTTOACQUIRE],
    [ORGANIZATIONCOSTPERTHOUSAND],
    [ORGANIZATIONNETPERTHOUSAND],
    [ORGANIZATIONGROSSPERTHOUSAND],
    [FIRSTRESPONSEDATE]
  from dbo.[MKTSEGMENTATIONACTIVE]
  where [ID] = @SEGMENTATIONID;

  return 0;