spFundRaiserBaseGiftTotals

Parameters

Parameter	Parameter Type	Mode	Description
@FundRaiserBaseID	int	IN
@IDIsTeam	bit	IN

Definition

Copy



CREATE   PROCEDURE dbo.spFundRaiserBaseGiftTotals
(
@FundRaiserBaseID int,
@IDIsTeam bit
)
AS

If @IDIsTeam = 1 

    SELECT
    TotalDonation.isOffline, sum(TotalDonation.Amount) as FundRaiserAmount
    FROM
    dbo.FundRaiserTeams Team
    inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.TeamID = Team.ID
    inner join dbo.FundRaiserDonations TotalDonation on TotalDonation.SolicitorID = Solicitor.ID
    WHERE
    Team.ID = @FundRaiserBaseID
    group by TotalDonation.isOffline

else

    SELECT
    TotalDonation.isOffline, sum(TotalDonation.Amount) as FundRaiserAmount
    FROM
    dbo.FundRaiserSolicitors Solicitor
    inner join dbo.FundRaiserDonations TotalDonation on TotalDonation.SolicitorID = Solicitor.ID
    WHERE Solicitor.ID = @FundRaiserBaseID
    group by TotalDonation.isOffline