USP_SIMPLEDATALIST_GROUPGOAL

            CREATE procedure dbo.USP_SIMPLEDATALIST_GROUPGOAL
            (
                @COMMITTEEID uniqueidentifier
            )
            as

            select
                GROUPGOAL.[ID] as [VALUE],
                GROUPGOAL.[NAME] as [LABEL]
            from dbo.COMMITTEE
                inner join GROUPGOAL
            on GROUPGOAL.[GROUPID] = COMMITTEE.[ID]
                left join GROUPGOALUNITCODE
            on GROUPGOALUNITCODE.[ID] = GROUPGOAL.[GROUPGOALUNITCODEID]
                where COMMITTEE.[ID] = @COMMITTEEID
                    and GROUPGOAL.[ISFUNDRAISINGGOAL] = 0
            order by [LABEL]