spTransactions_MarkEventRegAsProcessed
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TransID | int | IN |
Definition
Copy
CREATE procedure dbo.spTransactions_MarkEventRegAsProcessed(@TransID int)
as
update dbo.EventTransactions set processed_date=getutcdate()
where EventTransactionsID=@TransID
update dbo.EventItemCapacity
SET processed = 1
WHERE EventTransactionsID=@TransID