fnFundRaiserPageID

            CREATE function [dbo].[fnFundRaiserPageID]
                (    
                @FundRaiserBaseID int,
                @PageType int
                )
            returns int
            as
            begin
            declare @PageID int
            set @PageID=0
            if @PageType=1 --FundRaiserSolicitor
                begin
                    select @PageID=coalesce(frp.ID,0) 
                    from FundRaiserSolicitors frs 
                    inner join UserPersonalPages upp on upp.ParentID=frs.ID and upp.IsHome=1
                    inner join FundRaiserPages frp on frp.ID=upp.FundRaiserPageID
                    where frs.ID=@FundRaiserBaseID and (frp.PageType=@PageType or frp.PageType=0)


                    if @PageID=0
                        select @PageID=frp.ID from FundRaiserPages frp
                        left join Fundraisersolicitors frs on frs.id = @FundRaiserBaseID
                        where frp.FundRaiserID=frs.RootFundRaiserID
                        and frp.IsDefault=1 and (frp.PageType=@PageType or frp.PageType=0)

                end
            else if @PageType=2 --FundRaiserTeam
                begin
                    select @PageID=coalesce(frp.ID,0)
                    from FundRaiserTeams frt 
                    inner join FundRaiserPages frp on frp.ID=frt.FundRaiserPageID
                    where frt.ID=@FundRaiserBaseID and (frp.PageType=@PageType or frp.PageType=0)

                    if @PageID=0
                        select @PageID=frp.ID from FundRaiserPages frp
                        left join FundraiserTeams frt on frt.id = @FundRaiserBaseID
                        where frp.FundRaiserID=frt.RootFundraiserID
                        and frp.IsDefault=1 and (frp.PageType=@PageType or frp.PageType=0)

                end
            return @PageID
            end