/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 vote290 views1 answer
Sql select column names starting with
SQL
0 vote297 views2 answers
Mysql add days to date
SQL
0 vote302 views1 answer
Mysql find db contarint
SQL
5 votes302 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote300 views1 answer
Mysql grant user wildcard database
SQL
7 votes299 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote324 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote287 views1 answer
How to print longest name in sql
SQL
5 votes295 views1 answer
Oracle get nls settings
SQL
0 vote325 views1 answer
Tinydb add table
SQL