USP_KPI_COMMITTEE_GROUPGOALAMOUNTVALUE

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

                set @VALUE = 0;


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


                end