/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

4 votes339 views3 answers
Drop Table Oracle
SQL
1 vote372 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote348 views1 answer
Mysql size int
SQL
0 vote340 views1 answer
Narural join
SQL
9 votes326 views2 answers
Oracle all tables in schema
SQL
0 vote322 views1 answer
Soql more than today
SQL
0 vote383 views1 answer
Implode in sql query
SQL
0 vote315 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
15 votes361 views3 answers
Postgresql change column type
SQL
0 vote347 views1 answer
Mysql 8 error on identified by
SQL