/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

1 vote210 views2 answers
Mysql switch case
SQL
1 vote207 views3 answers
Drop unique key constraint in sql server
SQL
0 vote246 views1 answer
Search In the Data using ObjectName
SQL
2 votes214 views1 answer
Guid to string sql
SQL
15 votes272 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote191 views1 answer
How to Remove milliseconds from Date time
SQL
-1 vote233 views4 answers
Restart mysql server ubuntu
SQL
3 votes160 views1 answer
If 0 return null else return query mysql
SQL
0 vote209 views1 answer
Select all columns except one sql
SQL
5 votes198 views5 answers
Sqlite install python
SQL