spFundRaiserBaseActionTotalsByType

            CREATE    PROCEDURE [dbo].[spFundRaiserBaseActionTotalsByType]
            (
            @FundRaiserBaseID int,
            @IDIsTeam bit,
            @Type int
            )
            AS

            If @IDIsTeam = 1

                If @type = 0 
                --Team Select - All Types        

                    SELECT 
                    Count(FRAction.ID) as ActionTotal,
                    FRAction.Type
                    FROM
                    dbo.FundraiserSolicitorContactAction FRAction
                    inner join dbo.fnFundRaiserTeamSolicitors(@FundRaiserBaseID, 0, 0) Solicitor ON Solicitor.SolicitorID = FRAction.FundraiserSolicitorsID
                    GROUP BY FRAction.Type

                else
                --Team Select - Specific Type

                    SELECT 
                    Count(FRAction.ID) as ActionTotal,
                    FRAction.Type
                    FROM
                    dbo.FundraiserSolicitorContactAction FRAction
                    inner join dbo.fnFundRaiserTeamSolicitors(@FundRaiserBaseID, 0, 0) Solicitor ON Solicitor.SolicitorID = FRAction.FundraiserSolicitorsID
                    WHERE
                    FRAction.Type = @type
                    GROUP BY FRAction.Type

            else

                If @type = 0         
                --Solicitor Select - All Types    

                    SELECT 
                    Count(FRAction.ID) as ActionTotal,
                    FRAction.Type
                    FROM
                    dbo.FundraiserSolicitorContactAction FRAction
                    inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ID = FRAction.FundraiserSolicitorsID
                    WHERE
                    Solicitor.ID = @FundRaiserBaseID
                    GROUP BY FRAction.Type
                else
                --Solicitor Select - Particular Type            

                    SELECT 
                    Count(FRAction.ID) as ActionTotal,
                    FRAction.Type
                    FROM
                    dbo.FundraiserSolicitorContactAction FRAction
                    inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ID = FRAction.FundraiserSolicitorsID
                    WHERE
                    Solicitor.ID = @FundRaiserBaseID
                    and
                    FRAction.Type = @type
                    GROUP BY FRAction.Type