spDeleteGiftsDeletedInRE

                CREATE PROCEDURE [dbo].[spDeleteGiftsDeletedInRE]
                (
                    @BackOfficeIDs nvarchar(4000),
                    @FundID int
                )
                AS
                BEGIN
                    DECLARE @Temp TABLE(ID int, DTID int)

                    INSERT INTO @Temp
                    SELECT frd.ID, frd.DonationTransactionsID
                    FROM dbo.FundraiserDonations frd 
                    INNER JOIN dbo.FundRaiserSolicitors frs on frs.RootFundraiserID = @FundID and frs.ID = frd.SolicitorID 
                    INNER JOIN dbo.fnCSVIDsToTable(@BackOfficeIDs) ids ON ids.ID = frd.GiftBackOfficeID

                    UPDATE dbo.DonationTransactions SET IsDeleted = 1
                    FROM dbo.DonationTransactions dt
                    INNER JOIN @Temp ids ON ids.DTID = dt.DonationTransactionsID

                    DELETE FROM dbo.FundraiserDonations 
                    FROM dbo.FundraiserDonations frd 
                    INNER JOIN @Temp ids ON ids.ID = frd.ID
                END