spFundRaiserActionTotalsByType

Parameters

Parameter	Parameter Type	Mode	Description
@FundRaiserID	int	IN
@Type	int	IN
Definition

Copy


            CREATE   PROCEDURE dbo.spFundRaiserActionTotalsByType
            (
            @FundRaiserID int,
            @Type int
            )
            AS

            If @type = 0 

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

            else

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