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