/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 vote193 views1 answer
Convert to hexadecimal sql
SQL
0 vote265 views1 answer
Mysql grant access to one database
SQL
0 vote159 views1 answer
How to check if there is no database schema
SQL
0 vote176 views2 answers
Postgresql get long running queries
SQL
1 vote165 views2 answers
Drop function in sql
SQL
0 vote170 views2 answers
Sql server Insert Into table
SQL
8 votes288 views2 answers
Oracle auto increment primary key
SQL
5 votes202 views1 answer
How to use rank function in sql
SQL
1 vote198 views2 answers
Changes not showing on website server odoo
SQL
0 vote171 views1 answer
Vbscript connect mssql
SQL