spGet_DonorScrollerDonationIDs

            create procedure [dbo].[spGet_DonorScrollerDonationIDs]
            (
                @FrIDs nvarchar(4000)
            )
            as
            begin
                set nocount on
                declare @IDTable table
                (
                    ID int
                )
                insert into @IDTable select ID from dbo.fnMakeIDsTableFromString(@FrIDs, ',')

                select    fd.[ID],
                        fd.SolicitorID, 
                        fd.Amount,
                        fd.IsOffline,
                        fd.CurrencyType,
                        fd.IsAthon,
                        fd.InvoiceDate,
                        fd.InvoicePaid,
                        fd.PledgeID,
                        dt.DonationTransactionsID, 
                        dt.DateAdded,
                        dt.processed_date DateProcessed,
                        frs.AthonUnits
                from dbo.Fundraiserdonations fd inner join FundraiserSolicitors frs on frs.id = fd.solicitorid
                inner join dbo.DonationTransactions dt on dt.DonationTransactionsID = fd.DonationTransactionsID
                inner join @IDTable it on it.id=frs.RootFundraiserID
                where dt.IsDeleted = 0 and
                dt.Status = 1 and ISNULL(fd.PledgeID,0) = 0
                order by dt.DateAdded
            end