USP_KPI_COMMITTEE_GROUPGOALAMOUNTTOTAL

Parameters

Parameter	Parameter Type	Mode
@VALUE	int	INOUT
@ASOFDATE	datetime	IN
@COMMITTEEID	uniqueidentifier	IN
@GROUPGOALID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_KPI_COMMITTEE_GROUPGOALAMOUNTTOTAL(
                @VALUE int output,
                @ASOFDATE datetime,
                @COMMITTEEID uniqueidentifier,
                @GROUPGOALID uniqueidentifier
                ) as begin
                set nocount on;

                    set @VALUE = 0

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


                end