/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 vote73 views1 answer
Mysql workbench search all tables
SQL
0 vote118 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote109 views1 answer
Pl sql constraint user function
SQL
5 votes110 views2 answers
Mysqldump password
SQL
0 vote115 views1 answer
Get duplicate entry sql
SQL
0 vote137 views1 answer
SQL joins in python
SQL
0 vote126 views1 answer
Set engine to innodb
SQL
0 vote115 views1 answer
Get only one row in mysql
SQL
0 vote103 views1 answer
Full syntax inner join
SQL
25 votes113 views6 answers
Sql update query
SQL