fnFundRaiserAll

            CREATE  function [dbo].[fnFundRaiserAll]
            (@FundRaiserID int)
            returns @results table(FundRaiserAllID int identity (1, 1) not null, [ID] int, [Name] nvarchar(512), SitePageID int, IsTeam bit, Dirty bit, ClientUsersID int, [PageName] nvarchar(255), UserPersonalPageID int) as
            begin
            insert into @results
            select [ID], [Name], SitePageID, 0 'IsTeam', Dirty, ClientUsersID , PageName, UserPersonalPageID
                from dbo.fnFundRaiserSolicitorsAll(@FundRaiserID)
            union 
            select [ID], [Name], SitePageID, 1 'IsTeam', Dirty, null , null, null
                from dbo.fnFundRaiserTeamsAll(@FundRaiserID)
            return
            end