/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 vote322 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote319 views1 answer
Sql server query database space available
SQL
1 vote319 views1 answer
Postgresql escape single quote
SQL
0 vote354 views1 answer
Sparql list all graphs
SQL
0 vote341 views1 answer
Firebase sql
SQL
2 votes311 views3 answers
Postgresql reset auto increment
SQL
12 votes289 views4 answers
SQL Where
SQL
0 vote296 views1 answer
Mysql update sequence with order by
SQL
5 votes302 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote322 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL