spFundRaiserTeamsOverview

            CREATE    PROCEDURE [dbo].[spFundRaiserTeamsOverview]
                (@FUNDRAISERTEAMID INT)
            AS
            BEGIN
                 DECLARE @TOTAL MONEY
                 DECLARE @TOTALONLINE MONEY
                 DECLARE @ONLINECOUNT INT
                 DECLARE @TOTALOFFLINE MONEY
                 DECLARE @OFFLINECOUNT INT
                 DECLARE @TOTALCOUNT INT


                 SELECT 
                 @TOTALOFFLINE = ISNULL(SUM(OFFLINEDONATION.AMOUNT),0),
                 @OFFLINECOUNT =  COUNT(OFFLINEDONATION.ID)
                FROM
                 DBO.fnFundRaiserTeamSolicitors(@FUNDRAISERTEAMID, 0, 0) SOLICITOR
                 LEFT JOIN DBO.FUNDRAISERDONATIONS OFFLINEDONATION ON OFFLINEDONATION.SOLICITORID = SOLICITOR.SolicitorID        
                 WHERE
                 OFFLINEDONATION.ISOFFLINE = 1

                 SELECT
                @TOTALONLINE = ISNULL(SUM(ONLINEDONATION.AMOUNT),0),
                @ONLINECOUNT = COUNT(ONLINEDONATION.ID)
                 FROM
                 DBO.fnFundRaiserTeamSolicitors(@FUNDRAISERTEAMID, 0,  0) SOLICITOR
                 LEFT JOIN DBO.FUNDRAISERDONATIONS ONLINEDONATION ON ONLINEDONATION.SOLICITORID = SOLICITOR.SolicitorID        
                 WHERE
                 ONLINEDONATION.ISOFFLINE = 0

                 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