USP_KPI_EVENTS_TEAMFUNDRAISINGTEAMPERFORMANCE_GOAL

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@TEAMID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



                    CREATE procedure dbo.USP_KPI_EVENTS_TEAMFUNDRAISINGTEAMPERFORMANCE_GOAL
                    (
                        @VALUE money output, 
                        @TEAMID uniqueidentifier,
                        @CURRENCYID uniqueidentifier = null
                    )
                    as

                        set nocount on;

                        --Because we are forcing the currency to be the team's appeal's base, we can just get the 

                        --    AMOUNT off the team tables without having to worry about any conversions.


                        set @VALUE=0;

                        select @VALUE=GOAL
                        from dbo.TEAMFUNDRAISINGTEAM
                        where ID=@TEAMID