fnFundRaiserTeamsAll

            CREATE       function [dbo].[fnFundRaiserTeamsAll]
            (
            @FundRaiserID int
            )
            returns table as
            return(
            select frt.ID, frt.Name, frp.SitePageID, frt.Dirty
            FROM
            FundRaiserTeams frt
            left join FundRaiserPages frp on frp.ID=dbo.fnFundRaiserPageID(frt.ID,2)
            where
            frt.rootfundraiserid = @FundRaiserID
            )