spSolicitorDonations

            CREATE          PROCEDURE [dbo].[spSolicitorDonations]
            (
            @SolicitorID int,
            @SortBy int = 0,
            @SortOrder int = 1
            )
            AS
            SELECT     fd.[ID],
            fd.Amount,
            fd.IsOffline,
            fd.DonationTransactionsID,
            fd.CurrencyType,
            fd.IsAthon,
            fd.InvoiceDate,
            fd.InvoicePaid,
            fd.PledgeID,
            fd.GiftBackOfficeID,
            fd.SolicitorID,
            fd.IsChangeBucket,
            dt.DateAdded,
            dt.processed_date DateProcessed,
            dt.IsDeleted
            from FundRaiserDonations fd
            inner join DonationTransactions dt on dt.DonationTransactionsID = fd.DonationTransactionsID
            inner join FundRaiserSolicitors frs on frs.ID = fd.SolicitorID
            where fd.[SolicitorID] = @SolicitorID and not exists (select 'null' from FundRaiserDonations fd2 where fd2.PledgeID = fd.ID)
            and dt.Status = 1
            order by fd.IsChangeBucket desc,
            case
            when @SortOrder = 1 then null
            when @SortBy = 0 then dt.DateAdded
            when @SortBy = 1 then case fd.IsAthon when 0 then fd.Amount else fd.Amount * frs.AthonUnits end
            end asc,
            case
            when @SortOrder = 0 then null
            when @SortBy = 0 then dt.DateAdded
            when @SortBy = 1 then case fd.IsAthon when 0 then fd.Amount else fd.Amount * frs.AthonUnits end
            end desc

            RETURN