spTeamTeams

            CREATE    PROCEDURE [dbo].[spTeamTeams]
                    (
                        @TeamID int
                    )
                AS
                    SELECT     [ID],
                    [BackOfficeID]    ,
                    [FundRaiserID]     ,
                    [Name]        ,
                    [CaptainID]    ,
                    [ReportsToID]     ,
                    dbo.fnFundRaiserPageID([ID],2) [FundRaiserPageID],
                    [Goal]        ,
                    [Dirty]
                    FROM FundRaiserTeams WHERE ReportsToID = @TeamID
                    ORDER BY [Name]
                RETURN