spFundRaiserGiftTotals

            CREATE    PROCEDURE dbo.spFundRaiserGiftTotals
            (
            @FundRaiserID int
            )
            AS
            --sec
            --doesn't ignore deleted transactions
            SELECT
            TotalDonation.isOffline, sum(TotalDonation.Amount) as FundRaiserAmount
            FROM
            dbo.FundRaiserDonations TotalDonation
            inner join dbo.FundraiserSolicitors Solicitor on Solicitor.ID = TotalDonation.SolicitorID
            WHERE Solicitor.RootFundraiserID = @FundRaiserID
            group by TotalDonation.isOffline