fnTransactions_GetUnprocessedGifts
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientDonationsID | int | IN |
Definition
Copy
CREATE function [dbo].[fnTransactions_GetUnprocessedGifts](@ClientDonationsID int)
returns table as
return (
select top 100 percent DonationTransactionsID,DateAdded,AddedByUserID,XMLObjectData
from dbo.DonationTransactions where
ClientDonationsID = @ClientDonationsID
and processed_date is null
and [Status]=1
order by ClientDonationsID
)