spTransactions_GetLatestUnprocessedSignonUpdate
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientID | int | IN | |
| @UserID | int | IN |
Definition
Copy
CREATE procedure dbo.spTransactions_GetLatestUnprocessedSignonUpdate(@ClientID int,@UserID int)
as
select top 1 SignupTransactionsID,DateLastChanged ,XMLObjectData
from dbo.SignupTransactions where
clientsID = @ClientID and UserID = @UserID
and processed_date is null
order by DateLastChanged desc