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