/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 vote278 views1 answer
Trigger stock phpmyadmin
SQL
1 vote288 views1 answer
Floor function in sql oracle
SQL
0 vote275 views1 answer
Get initials name in sql
SQL
0 vote249 views1 answer
Psql check if value in array
SQL
0 vote265 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote265 views1 answer
Select row with latest date mysql
SQL
0 vote272 views1 answer
Closure in sql
SQL
0 vote263 views1 answer
Exectuer myssql .sql
SQL
-1 vote266 views3 answers
SQL MM/dd/yyyy format
SQL
5 votes253 views2 answers
Mysql date greater than 30 days
SQL