USP_SIMPLEDATALIST_FUNDRAISINGGOAL

            CREATE procedure dbo.USP_SIMPLEDATALIST_FUNDRAISINGGOAL
            (
                @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] = 1
            order by [LABEL]