spDonationTransactionsByFundRaiser

             CREATE procedure [dbo].[spDonationTransactionsByFundRaiser]
            (
                 @FrIDs nvarchar(4000)
            )
            as
                BEGIN
                    select dt.DonationTransactionsID, fr.Name as 'FundRaiser', ft.Name as 'Team', dt.XmlObjectData
                    from dbo.Fundraiserdonations frd inner join dbo.FundraiserSolicitors frs on frs.id = frd.solicitorid
                    inner join dbo.FundRaisers fr on frs.RootFundraiserID = fr.id
                    inner join dbo.DonationTransactions dt on dt.DonationTransactionsID = frd.DonationTransactionsID
                    left outer join dbo.FundraiserTeams ft on ft.ID = frs.TeamID
                    where dt.IsDeleted = 0 and dt.Status = 1 and frs.RootFundraiserID in (select * from dbo.fnMakeIDsTableFromString(@FrIDs, ','))
                END