USP_DATALIST_TEAMFUNDRAISINGTEAM

                CREATE procedure dbo.USP_DATALIST_TEAMFUNDRAISINGTEAM
                (
                        @EVENTID uniqueidentifier
                )
                as
                    set nocount on;

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