spFundRaiserTeamTopSolicitors

Parameters

Parameter	Parameter Type	Mode
@FundRaiserTeamID	int	IN
@Results	int	IN
@Top	bit	IN

Definition

Copy



CREATE   PROCEDURE dbo.spFundRaiserTeamTopSolicitors
(
@FundRaiserTeamID int,
@Results int,
@Top bit
)

AS

SET ROWCOUNT @Results


    if @Top = 1

        SELECT 
        Solicitor.ID as FundRaiserSolicitorID
        FROM
        dbo.FundRaiserTeams Team
        inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.TeamID = Team.ID
        left join dbo.FundRaiserDonations Donations on  Donations.SolicitorID = Solicitor.ID
        WHERE
        Team.ID = @FundRaiserTeamID
        GROUP BY Solicitor.ID 
        ORDER BY Sum(Donations.Amount) 
        DESC

    else

        SELECT 
        Solicitor.ID as FundRaiserSolicitorID
        FROM
        dbo.FundRaiserTeams Team
        inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.TeamID = Team.ID
        left join dbo.FundRaiserDonations Donations on  Donations.SolicitorID = Solicitor.ID
        WHERE
        Team.ID = @FundRaiserTeamID
        GROUP BY Solicitor.ID 
        ORDER BY Sum(Donations.Amount) 
        ASC


SET ROWCOUNT 0