UFN_TRANSACTIONS_GETUNPROCESSEDEVENTREGISTRATIONSFORUSER
Returns a table of unprocessed event registration transactions for given user
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @USERID | int | IN |
Definition
Copy
create function dbo.UFN_TRANSACTIONS_GETUNPROCESSEDEVENTREGISTRATIONSFORUSER
(
@USERID as integer
)
returns table as
return
(
select top 100 percent EventTransactionsID, XMLObjectData
from dbo.EventTransactions
where AddedByUserID = @USERID and processed_date is null and [Status] = 1
order by EventTransactionsID
)