fnFundRaiserSolicitorsAll

            CREATE function [dbo].[fnFundRaiserSolicitorsAll]
            (
            @FundRaiserID int
            )

            returns table as
            return(
            select frs.ID, case len(cu.FirstName) when 0 then cu.LastName else cu.FirstName + ' ' + cu.LastName end as 'Name', frp.SitePageID, frs.Dirty, frs.ClientUsersID, upp.Name as 'PageName', upp.ID as 'UserPersonalPageID', frs.Goal
            from clientusers cu
            inner join FundRaiserSolicitors frs on frs.ClientUsersID=cu.ID
            inner join UserPersonalPages upp on upp.ParentID=frs.ID
            --blg 07.19.2007  CR277977-062807
            --inner join FundRaiserPages frp on frp.ID=upp.FundRaiserPageID
            inner join FundRaiserPages frp on frp.ID=dbo.fnFundRaiserPageID(frs.ID,1)
            where
            (frs.RootFundRaiserID = @FundRaiserID)
            --trw 02-07-07 Removed the recursive call since we added RootFundraiserID to the Solicitors table
            --or dbo.fnGetFundRaiserIDForSolicitor(frs.ReportsToID) = @FundRaiserID
            --or dbo.fnGetFundRaiserIDForTeam(frs.TeamID) = @FundRaiserID)
            and cu.Deleted=0
            -- blg 11.01.2007  CR286778-102907
            -- and frs.Inactive=0
            and upp.IsPublished=1
            )