USP_DATALIST_TEAMFUNDRAISINGTEAMGETNAME

    CREATE procedure dbo.USP_DATALIST_TEAMFUNDRAISINGTEAMGETNAME
                (
                        @TEAMFUNDRAISINGTEAMID 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 T.ID = @TEAMFUNDRAISINGTEAMID