spFundraiserTopDonation

        CREATE    PROCEDURE [dbo].[spFundraiserTopDonation]
                    (@FrIds nvarchar(4000))

            AS
                SELECT
                    TOP 1 isnull(frdonation.amount,0), frdonation.DonationTransactionsID, Donation.XMLObjectData
                FROM
                    dbo.DonationTransactions Donation
                    inner join dbo.FundRaiserDonations FRDonation on FRDonation.DonationTransactionsID = Donation.DonationTransactionsID
                    inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ID = FRDonation.SolicitorID
                    inner join dbo.fnMakeIDsTableFromString(@FrIds, ',') ids on Solicitor.RootFundRaiserID = ids.ID
                WHERE
                    donation.isDeleted = 0 and
                    donation.Status = 1
                ORDER BY 
                    frdonation.amount DESC, donation.LastName ASC