/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 vote124 views2 answers
Laravel: customize or extend notifications - database model
SQL
2 votes120 views1 answer
Mysql set value as null
SQL
0 vote139 views1 answer
Postgres reorder columns
SQL
1 vote123 views1 answer
STOP message of how many rows affected sql
SQL
2 votes117 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote133 views1 answer
Mysql coonect sample code
SQL
1 vote117 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote125 views1 answer
How to update date add hours in postgresql
SQL
9 votes119 views2 answers
Sql server check table exists
SQL
0 vote133 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL