/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 vote178 views1 answer
Mysqli last row
SQL
1 vote291 views3 answers
Sql subquery
SQL
2 votes218 views2 answers
Mysql compare datetime to another datetime
SQL
2 votes178 views4 answers
Mysql get all tables row count
SQL
0 vote186 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote177 views1 answer
Oracle sql developer closed connection
SQL
3 votes209 views1 answer
What is having
SQL
17 votes190 views4 answers
Postgres list users
SQL
0 vote172 views1 answer
Oracle sql generate list of days
SQL
2 votes159 views1 answer
Oracle sql day of month from date
SQL