<div>
Hej,<br />
<br />
My programmer has written the following :<br />
<br />
UPDATE TOP (1) ReportTemplateSchedules SET sch_Running = 'T', sch_NextRuntime = NULL OUTPUT inserted.* WHERE sch_Running = 'F' AND sch_id in (SELECT TOP 1 sch_id FROM ReportTemplateSchedules WHERE sch_NextRunTime &lt;&nbsp;'some date' ORDER BY sch_NextRunTime asc)<br />
<br />
He sets the sch_Running flag true, and the sch_Runtime to NULL to the top record and then checks to see any data is returned.<br />
<br />
DO you see anything wrong with this... it seems to be similar to your example except it uses on statement?
</div>


Hej,

My programmer has written the following :

UPDATE TOP (1) ReportTemplateSchedules SET sch_Running = 'T', sch_NextRuntime = NULL OUTPUT inserted.* WHERE sch_Running = 'F' AND sch_id in (SELECT TOP 1 sch_id FROM ReportTemplateSchedules WHERE sch_NextRunTime < 'some date' ORDER BY sch_NextRunTime asc)

He sets the sch_Running flag true, and the sch_Runtime to NULL to the top record and then checks to see any data is returned.

DO you see anything wrong with this... it seems to be similar to your example except it uses on statement?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a table that represents a queue, where many applications are reading and processing the top of the queue. &nbsp;The top item is not deleted from the queue - just marked as &quot;being processed&quot;<br />
<br />
How do i best handle this so that i dont end up with two applications symultaneously reading the top entry and trying to handle it? &nbsp;Should i put all my code in a stored procedure and wrap a transaction around it?<br />
<br />

</div>
</div>


Hello,

I have a table that represents a queue, where many applications are reading and processing the top of the queue.  The top item is not deleted from the queue - just marked as "being processed"

How do i best handle this so that i dont end up with two applications symultaneously reading the top entry and trying to handle it?  Should i put all my code in a stored procedure and wrap a transaction around it?



MS SQL - How to handle a table that queue

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.