/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 vote282 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote302 views1 answer
Sql with example
SQL
0 vote264 views1 answer
Sql get month and year from date
SQL
0 vote263 views1 answer
Date diff sql
SQL
4 votes285 views1 answer
Oracle error line
SQL
8 votes294 views4 answers
Postgresql server restart
SQL
0 vote302 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote266 views1 answer
Table values functions in SQL
SQL
1 vote289 views3 answers
Sql procedure
SQL
0 vote259 views1 answer
Mysql auto increment default value with prefix month and year
SQL