spFundRaiserOverview

            CREATE    PROCEDURE dbo.spFundRaiserOverview
            (@FundRaiserID int)
            AS
            BEGIN
                DECLARE @total money
                DECLARE @totalonline money
                DECLARE @onlinecount int
                DECLARE @totaloffline money
                DECLARE @offlinecount int
                DECLARE @totalcount int
            --counts deleted Donations    
                SELECT 
                @totaloffline = isnull(sum(offlinedonation.amount),0),
                @offlinecount =  count(offlinedonation.id)
                FROM
                dbo.FundRaiserSolicitors Solicitor
                left join dbo.FundRaiserDonations offlinedonation on offlinedonation.solicitorid = Solicitor.id        
                WHERE
                offlinedonation.isoffline = 1
                and
                Solicitor.RootFundraiserID = @FundraiserID

                SELECT
                @totalonline = isnull(sum(onlinedonation.amount),0),
                @onlinecount = count(onlinedonation.id)
                FROM
                dbo.FundRaiserSolicitors Solicitor
                left join dbo.FundRaiserDonations onlinedonation on onlinedonation.solicitorid = Solicitor.id        
                WHERE
                onlinedonation.isoffline = 0
                and
                Solicitor.RootFundraiserID = @FundraiserID


                if @@rowcount > 0 
                BEGIN
                    set @total = @totalonline+@totaloffline
                    set @totalcount = @offlinecount+@onlinecount

                END

                SELECT @total as TotalDonationAmount, @totalonline as TotalOnlineAmount, @onlinecount as TotalOnlineCount, @totaloffline as TotalOfflineAmount, @offlinecount as TotalOfflineCount, @totalcount as TotalDonationCount

            END