fnFundRaiserChildSolicitorsForTeam

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

            select
            frs.ID, frs.Goal, case len(cu.FirstName) when 0 then cu.LastName else cu.FirstName + ' ' + cu.LastName end as 'Name',frp.SitePageID
            from dbo.FundRaiserSolicitors frs
            inner join dbo.FundRaiserPages frp on frp.ID = dbo.fnFundRaiserPageID(frs.ID, 1)
            inner join dbo.ClientUsers cu on cu.ID = frs.ClientUsersID
            where
            dbo.fnGetSolicitorIsPartOfTeam(frs.ID, @TeamID)= 1
            and cu.Deleted=0
            )