fnFundRaiserChildTeamsForTeam

            CREATE  function [dbo].[fnFundRaiserChildTeamsForTeam](@TeamID int)
            returns table
            as
            return(

            select
            frt.ID TeamID, frt.Name as 'TeamName', frt.Goal, frp.SitePageID
            from  FundRaiserTeams frt
            inner join FundRaiserPages frp on frp.ID = dbo.fnFundRaiserPageID(frt.ID, 2)
            where frt.ReportsToID is not null
            and dbo.fnGetTeamIsPartOfTeam(frt.ID, @TeamID)= 1
            )