spFundRaiserDashboardSolicitorEmailTotals

Parameters

Parameter	Parameter Type	Mode
@FundRaiserID	int	IN
@FundRaiserTeamID	int	IN
@FundRaiserSolicitorID	int	IN
Definition

Copy


            CREATE   PROCEDURE dbo.spFundRaiserDashboardSolicitorEmailTotals
            (
            @FundRaiserID int,
            @FundRaiserTeamID int,
            @FundRaiserSolicitorID int
            )

            AS
            -- --Fundraiser All
            -- 
            --     SELECT
            --     Count(FREmail.Type) 'Count',
            --     FREmail.Type    
            --     FROM
            --     dbo.FundraiserSolicitorEmail FREmail
            --     inner join dbo.fnFundRaiserSolicitorsAll(@FundRaiserID) Solicitor on FREmail.FundRaiserSolicitorsID = Solicitor.ID 
            --     GROUP BY
            --     FREmail.Type

            --Fundraiser All
                 SELECT
                 Count(FREmail.Type) 'Count',
                 FREmail.Type    
                 FROM
                 dbo.FundraiserSolicitorEmail FREmail
                inner join dbo.FundRaiserSolicitors Solicitor on FREmail.FundRaiserSolicitorsID = Solicitor.ID 
                WHERE Solicitor.RootFundraiserID = @FundraiserID
                 GROUP BY
                 FREmail.Type

            --FundRaiser Team All

                SELECT
                Count(FREmail.Type) 'Count',
                FREmail.Type    
                FROM
                dbo.FundraiserSolicitorEmail FREmail
                inner join dbo.FundRaiserSolicitors Solicitor ON FREmail.FundRaiserSolicitorsID = Solicitor.ID 
                inner join dbo.fnFundRaiserChildTeamsForTeam(@FundRaiserTeamID) Team ON Solicitor.TeamID = Team.TeamID
                GROUP BY
                FREmail.Type

            --FundRaiser Solicitor All

                SELECT
                Count(FREmail.Type) 'Count',
                FREmail.Type    
                FROM
                dbo.FundraiserSolicitorEmail FREmail
                inner join dbo.FundRaiserSolicitors Solicitor ON FREmail.FundRaiserSolicitorsID = Solicitor.ID 
                WHERE
                Solicitor.ID = @FundRaiserSolicitorID
                GROUP BY
                FREmail.Type