USP_SMARTFIELD_AGGREGATEHOUSEHOLDREVENUEDATES

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@TYPECODES	xml	IN
@DESIGNATIONS	xml	IN
@AMOUNTCODES	xml	IN
@CALCULATIONTYPE	tinyint	IN
@ASOF	datetime	IN
@CAMPAIGNS	xml	IN

Definition

Copy



CREATE procedure dbo.USP_SMARTFIELD_AGGREGATEHOUSEHOLDREVENUEDATES
(
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @TYPECODES xml = null,
    @DESIGNATIONS xml = null,
    @AMOUNTCODES xml = null,
    @CALCULATIONTYPE tinyint = 0,
    @ASOF datetime = null,
    @CAMPAIGNS xml = null
)
as
    set nocount on;
    exec dbo.USP_HOUSEHOLDSMARTFIELD_AGGREGATEREVENUEAMOUNTS @STARTDATE, @ENDDATE, @TYPECODES, @DESIGNATIONS, 
                                                             @AMOUNTCODES, @CALCULATIONTYPE, @ASOF, @CAMPAIGNS;