spGet_DonorScrollerDonationsForTeam

            CREATE procedure [dbo].[spGet_DonorScrollerDonationsForTeam]
            (    
                @TeamID int,
                @Top int,
                @SortBy int
            )
            as
            begin
                set nocount on

                declare @RootFundraiserID int

                select @RootFundraiserID = RootFundraiserID FROM dbo.FundraiserTeams
                where [ID] = @TeamID

                select    top(@Top)

                        fd.[ID] DonationID,
                        fd.SolicitorID, 
                        fd.Amount,
                        fd.IsOffline,
                        fd.CurrencyType,
                        fd.IsAthon,
                        fd.InvoiceDate,
                        fd.InvoicePaid,
                        fd.PledgeID,
                        fd.GiftBackOfficeID,
                        dt.DonationTransactionsID, 
                        dt.XMLObjectData,
                        dt.DateAdded,
                        dt.processed_date DateProcessed,
                        dt.GiftPaymentMethod,
                        frs.AthonUnits
                from 
                    dbo.FundraiserSolicitors frs 
                    inner join dbo.fnFundRaiserTeamSolicitors(@TeamID, @RootFundraiserID, 3) fn on frs.ID = fn.SolicitorID
                    inner join dbo.Fundraiserdonations fd on frs.ID = fd.SolicitorID
                    inner join dbo.DonationTransactions dt on dt.DonationTransactionsID = fd.DonationTransactionsID
                where (fd.IsAthon = 0 or fd.InvoicePaid = 0) and dt.IsDeleted = 0 and dt.Status = 1    
                order by 
                    case
                        when @SortBy = 1 then case fd.IsAthon when 0 then fd.Amount else fd.Amount * frs.AthonUnits end 
                        when @SortBy = 3 then dt.DateAdded
                    end desc,
                    dt.LastName asc
            end