spFundraiserMulitpleSolicitors

            CREATE procedure [dbo].[spFundraiserMulitpleSolicitors]
            (
                @FrIDs nvarchar(4000),
                @ClientSitesID int
            )
            as
                BEGIN
                    select fs.ID As SolicitorID, 
                    sc.Title As FundRaiserName,
                    fs.Goal, isnull(ft.Independent,1) As Independent, 
                    ft.Name As TeamName 
                    from dbo.FundraiserSolicitors fs inner join dbo.Fundraisers fr on fs.RootFundraiserID = fr.ID 
                    left outer join dbo.FundraiserTeams ft on fs.TeamID = ft.ID
                    inner join dbo.SiteContent sc on fr.SiteContentID = sc.ID 
                    where sc.ClientSitesID = @ClientSitesID and 
                    fs.RootFundraiserID in (select * from dbo.fnMakeIDsTableFromString(@FrIDs, ',')) 
                END