USP_PROFILEUPDATETRANSACTIONS_MARK_COMPLETED
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @PROFILEUPDATETRANSACTIONSID | int | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_PROFILEUPDATETRANSACTIONS_MARK_COMPLETED
(
@ID uniqueidentifier,
@PROFILEUPDATETRANSACTIONSID int,
@CHANGEAGENTID uniqueidentifier
)
as begin
set nocount on;
update dbo.ProfileUpdateTransactions set processed_date = GETUTCDATE()
where ProfileUpdateTransactionsID = @PROFILEUPDATETRANSACTIONSID
update dbo.Transactions set BeginDownload = GETUTCDATE(), EndDownload = GETUTCDATE()
where TransactionType = '{DCEAFCC7-0290-488e-A194-953DE66D6AAB}' and TransactionID = @PROFILEUPDATETRANSACTIONSID
return 0;
end