spFundRaiserSolicitorTopSummaries

                CREATE PROCEDURE [dbo].[spFundRaiserSolicitorTopSummaries]

            (@FrIds nvarchar(4000))

            AS

            select top 10

            usr.FirstName,

            usr.LastName,

            scnt.title Fundraiser,

            frs.id FrsId,

            frt.Name TeamName,

            frt.id TeamId,

            frs.goal Goal,

            dbo.fnFundraiserSolicitorDonationTotal(frs.id) AmountRaised,

            fr.ID FrId

            from

            dbo.fundraiserSolicitors frs

            inner join dbo.fnMakeIDsTableFromString(@FrIds, ',') ids on ids.id = frs.rootfundraiserid

            inner join dbo.fundraisers fr on fr.id = frs.rootFundraiserId

            inner join dbo.sitecontent scnt on scnt.id = fr.siteContentId

            inner join dbo.clientusers usr on frs.ClientUsersId=usr.id and usr.Deleted = 0

            left join dbo.fundraiserTeams frt on frs.teamid = frt.id

            order by amountraised desc