spFundRaiserSolicitorDonorsByThanks

CREATE     PROCEDURE dbo.spFundRaiserSolicitorDonorsByThanks
(
@FundRaiserSolicitorsID int,
@Thanks bit 
)
AS


    BEGIN

    If @Thanks = 0

        SELECT     
        actions.AddressbookContactsID as 'AddressBookContactID',
        actions.FundraiserSolicitorContactID as 'SolicitorContactID',
        Sum(donations.amount) as 'TotalAmountDonated',
        Count(donations.ID) as 'DonationCount'
        FROM  
        dbo.FundraiserSolicitorContactAction actions
        inner join dbo.FundRaiserDonations donations on donations.id = actions.FundRaiserDonationsID
        WHERE
        actions.FundraiserSolicitorsID = @FundRaiserSolicitorsID
        AND
        donations.ThankedDate IS NULL         

        GROUP BY
        actions.FundraiserSolicitorContactID, actions.AddressbookContactsID

        ORDER BY    
        Sum(donations.amount)

    Else

        SELECT     
        actions.AddressbookContactsID as 'AddressBookContactID',
        actions.FundraiserSolicitorContactID as 'SolicitorContactID',
        Sum(donations.amount) as 'TotalAmountDonated',
        Count(donations.ID) as 'DonationCount'
        FROM  
        dbo.FundraiserSolicitorContactAction actions
        inner join dbo.FundRaiserDonations donations on donations.id = actions.FundRaiserDonationsID
        WHERE
        actions.FundraiserSolicitorsID = @FundRaiserSolicitorsID
        AND
        donations.ThankedDate IS NOT NULL

        GROUP BY
        actions.FundraiserSolicitorContactID, actions.AddressbookContactsID

        ORDER BY    
        Sum(donations.amount)

    END