/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 vote235 views1 answer
Add column alter table default value
SQL
2 votes236 views1 answer
Oracle drop sequence if exists
SQL
2 votes242 views2 answers
Mysql user access to database
SQL
3 votes226 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote221 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote246 views1 answer
Mssql + bit + in python orm
SQL
0 vote251 views1 answer
Sql decimal to 2 places
SQL
1 vote230 views1 answer
Oracle grant on all tables in schema
SQL
0 vote228 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote238 views1 answer
How to display value of variable in mysql
SQL