USP_SIMPLEDATALIST_TEAMFUNDRAISINGTEAM

                CREATE procedure dbo.USP_SIMPLEDATALIST_TEAMFUNDRAISINGTEAM 
                (
                        @EVENTID uniqueidentifier
                ) with execute as owner
                as
                set nocount on;

                SELECT 
                T.ID AS VALUE,
                T.NAME AS LABEL                
                FROM dbo.TEAMFUNDRAISINGTEAM T (NOLOCK)
                INNER JOIN dbo.EVENT E (NOLOCK)
                ON T.APPEALID = E.APPEALID
                WHERE E.ID = @EVENTID