USP_KPI_CAMPAIGNFUNDRAISER_GOALAMOUNTTOTAL

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@ASOFDATE	datetime	IN
@FUNDRAISERID	uniqueidentifier	IN
@CAMPAIGNID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@CURRENCYID	uniqueidentifier	IN
@CAMPAIGNFUNDRAISERID	uniqueidentifier	IN

Definition

Copy



                    CREATE procedure dbo.USP_KPI_CAMPAIGNFUNDRAISER_GOALAMOUNTTOTAL(
                        @VALUE money output, 
                        @ASOFDATE datetime,
                        @FUNDRAISERID uniqueidentifier,
                        @CAMPAIGNID uniqueidentifier,
                        @STARTDATE datetime = null,
                        @ENDDATE datetime = null,
                        @CURRENCYID uniqueidentifier = null,
            @CAMPAIGNFUNDRAISERID uniqueidentifier = null
                    ) as begin
                        set nocount on;

                        set @VALUE = dbo.UFN_KPI_CAMPAIGNFUNDRAISER_GOALAMOUNTTOTALINCURRENCY( @ASOFDATE, @FUNDRAISERID, @CAMPAIGNID, @STARTDATE, @ENDDATE, @CURRENCYID)

                    end