USP_DATAFORMTEMPLATE_VIEW_MARKETINGEFFORTPERFORMANCEREVIEWSUMMARY

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@COSTPERDOLLARRAISEDACTUAL	money	INOUT
@COSTTOACQUIREACTUAL	money	INOUT
@NETREVENUEACTUAL	money	INOUT
@GROSSREVENUEACTUAL	money	INOUT
@AVERAGEGIFTAMOUNTACTUAL	money	INOUT
@TOTALRESPONSESACTUAL	int	INOUT
@RESPONSERATEACTUAL	decimal(19, 4)	INOUT
@QUANTITYMAILED	int	INOUT
@COSTACTUAL	money	INOUT
@LAUNCHDATE	datetime	INOUT
@FIRSTRESPONSEDATE	datetime	INOUT

Definition

Copy



create procedure BBDW.USP_DATAFORMTEMPLATE_VIEW_MARKETINGEFFORTPERFORMANCEREVIEWSUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @COSTPERDOLLARRAISEDACTUAL money = null output,
  @COSTTOACQUIREACTUAL money = null output,
  @NETREVENUEACTUAL money = null output,
  @GROSSREVENUEACTUAL money = null output,
  @AVERAGEGIFTAMOUNTACTUAL money = null output,
  @TOTALRESPONSESACTUAL int = null output,
  @RESPONSERATEACTUAL decimal(19,4) = null output,
  @QUANTITYMAILED int= null output,
  @COSTACTUAL  money = null output,
  @LAUNCHDATE datetime = null output,
  @FIRSTRESPONSEDATE datetime = null output
  )
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

   select
      @DATALOADED = 1,
      @COSTPERDOLLARRAISEDACTUAL = SEGMENTATIONCOSTPERDOLLARRAISED,      
      @COSTTOACQUIREACTUAL = SEGMENTATIONCOSTTOACQUIRE,      
      @NETREVENUEACTUAL = SEGMENTATIONROIAMOUNT,      
      @GROSSREVENUEACTUAL = SEGMENTATIONTOTALGIFTAMOUNT,    
      @AVERAGEGIFTAMOUNTACTUAL = SEGMENTATIONAVERAGEGIFTAMOUNT,
      @TOTALRESPONSESACTUAL = SEGMENTATIONRESPONSES,      
      @RESPONSERATEACTUAL = SEGMENTATIONRESPONSERATE,
      @QUANTITYMAILED = SEGMENTATIONQUANTITY,      
      @COSTACTUAL = SEGMENTATIONTOTALCOST,            
      @LAUNCHDATE = SEGMENTATIONDATE,
      @FIRSTRESPONSEDATE = SEGMENTATIONFIRSTRESPONSEDATE
    from BBDW.DIM_MARKETINGSEGMENTATION
    where SEGMENTATIONSYSTEMID = @ID

    return 0;