USP_KPI_COMMITTEE_FUNDRAISINGGOALAMOUNTVALUE

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@COMMITTEEID	uniqueidentifier	IN
@GROUPGOALID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN

Definition

Copy



                    CREATE procedure dbo.USP_KPI_COMMITTEE_FUNDRAISINGGOALAMOUNTVALUE(
                        @VALUE money output,
                        @COMMITTEEID uniqueidentifier,
                        @GROUPGOALID uniqueidentifier,
                        @BASECURRENCYID uniqueidentifier = null
                    ) as begin
                    set nocount on;

                        set @VALUE = 0

                        select
                            @VALUE = GROUPGOAL.[AMOUNT]
                            from dbo.GROUPGOAL
                        where
                            GROUPGOAL.ID = @GROUPGOALID
                    end