USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTREVENUESUMMARYPARAMETERS

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@SITEFILTERMODE	tinyint	INOUT
@SITESSELECTED	xml	INOUT
@CURRENCYCODE	tinyint	INOUT
@DATEFILTER	tinyint	INOUT
@REVENUEFILTERID	uniqueidentifier	INOUT
@BREAKDOWNBY	tinyint	INOUT
@CAMPAIGNFILTERMODE	tinyint	INOUT
@CAMPAIGNSSELECTED	xml	INOUT
@STARTDATE	datetime	INOUT
@ENDDATE	datetime	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTREVENUESUMMARYPARAMETERS
(
    @DATALOADED bit = 0 output,
    @CONSTITUENTID uniqueidentifier = null output,
    @SITEFILTERMODE tinyint = null output,
    @SITESSELECTED xml = null output,
    @CURRENCYCODE tinyint = null output,
    @DATEFILTER tinyint = null output,
    @REVENUEFILTERID uniqueidentifier = null output,
    @BREAKDOWNBY tinyint = null output,
    @CAMPAIGNFILTERMODE tinyint = null output,
    @CAMPAIGNSSELECTED xml = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output
)
as
    set nocount on;
    set @DATALOADED = 1;

    return 0;