USP_KPI_OPPORTUNITYAMOUNTBYSELECTION_INTERNAL

Template used to generate an SP for use with KPIs.

Parameters

Parameter	Parameter Type	Mode
@ASOFDATE	datetime	IN
@FUNDRAISERID	uniqueidentifier	IN
@VALUE	money	INOUT

Definition

Copy



            create procedure dbo.USP_KPI_OPPORTUNITYAMOUNTBYSELECTION_INTERNAL
                @ASOFDATE datetime,
                @FUNDRAISERID uniqueidentifier = null,
                @VALUE money = 0 output
            as    
                set nocount on;

                select 
                    @VALUE = coalesce(sum(O.AMOUNT), 0)
                from
                    dbo.OPPORTUNITY O
                    inner join dbo.PROSPECTPLAN PP on PP.ID = O.PROSPECTPLANID
                    /*#IDSETEXTENSION*/
                where
                    (@FUNDRAISERID is null or PP.PRIMARYMANAGERFUNDRAISERID = @FUNDRAISERID);