/SQL/Loop through a table variable in TSQL without using a cursor

Loop through a table variable in TSQL without using a cursor

Declare @Id int
While (Select Count(*) From ATable Where Processed = 0) > 0
Begin
    Select Top 1 @Id = Id From ATable Where Processed = 0
    --Do some processing here
    Update ATable Set Processed = 1 Where Id = @Id 
End

Source: stackoverflow.com

Similar codes

0 vote146 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote136 views1 answer
Oracle create table auto generated primary key
SQL
2 votes146 views1 answer
Docker run postgres locally
SQL
0 vote129 views1 answer
Sql change primary key to composite key
SQL
16 votes153 views1 answer
Sql comment'
SQL
0 vote155 views1 answer
Sql basic commands
SQL
0 vote137 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
6 votes141 views3 answers
Create database mysql utf8
SQL
3 votes159 views1 answer
What is having
SQL
1 vote145 views1 answer
How to truncate a table in databse
SQL