Database

<pre>SELECT * FROM EVENT WHERE EVENTDATE >= CAST('NOW' AS DATE)  AND EVENTMSG ='Access Granted' 
 ORDER BY EVENTDATE

create table PendingQueue (
   id int not null,
   DueTime datetime not null,
   Payload varbinary(max),
   cnstraint pk_pending_id nonclustered primary key(id));
    
 create clustered index cdxPendingQueue on PendingQueue (DueTime);
 go
    
 create procedure usp_enqueuePending
   @dueTime datetime,
   @payload varbinary(max)
 as
   set nocount on;
   insert into PendingQueue (DueTime, Payload)
     values (@dueTime, @payload);
 go
    
 create procedure usp_dequeuePending
   @batchsize int = 100,
   @retryseconds int = 600
 as
   set nocount on;
   declare @now datetime;
   set @now = getutcdate();
   with cte as (
     select top(@batchsize) 
       id,
       DueTime,
       Payload
     from PendingQueue with (rowlock, readpast)
     where DueTime < @now
     order by DueTime)
   update cte
     set DueTime = dateadd(seconds, @retryseconds, DueTime)
     output deleted.Payload, deleted.id;
 go

BEGIN TRANSACTION
    
 SELECT @ID=RowID FROM MyTable WITH (ROWLOCK, XLOCK, HOLDLOCK) WHERE ID=6822