/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 vote116 views1 answer
How change the field place in mysql
SQL
6 votes140 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote143 views1 answer
Soql last week
SQL
0 vote157 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote95 views1 answer
Connection error in mysql workbench
SQL
1 vote89 views1 answer
Postgres division by zero
SQL
0 vote205 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote126 views1 answer
How to count with except in psql
SQL
3 votes135 views1 answer
Fk in insert mysql
SQL
1 vote149 views2 answers
Mysql insert generate serie
SQL