fnTransactions_GetAllGifts

            CREATE function [dbo].[fnTransactions_GetAllGifts](@ClientsID int , @BeginDate datetime)

            returns table as

            return (

            select top 100 percent DonationTransactionsID, ClientDonationsID, AddedByUserID, DateAdded, XMLObjectData, processed_date, IsDeleted, ClientsID, EmailID, GiftAmount, GiftPaymentMethod, GiftCurrencyType, LastName, TransactionGUID
            from dbo.DonationTransactions where
            ClientsID = @ClientsID AND DateAdded > @BeginDate and status = 1
            order by ClientDonationsID
            )