spTransactions_GetUnprocessedDonationTransactionForUser

            CREATE PROCEDURE [dbo].[spTransactions_GetUnprocessedDonationTransactionForUser]
            (
            @UserID int
            )
            AS
            BEGIN
                SET NOCOUNT ON;
                SELECT XMLObjectData FROM DonationTransactions
                WHERE (AddedByUserID=@UserID And processed_date Is NULL And Status=1
                        AND NOT EXISTS(SELECT TOP 1 (1)
                                    FROM  FundRaiserDonations frd
                                    WHERE frd.DonationTransactionsID = DonationTransactions.DonationTransactionsID AND frd.IsOffline=1))
            END