/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 vote229 views1 answer
Manage Database in MySQL
SQL
4 votes173 views1 answer
Oracle select first 10 rows
SQL
0 vote238 views1 answer
Replace null value within column mysql
SQL
2 votes179 views1 answer
Postgresql drop primary key constraint
SQL
11 votes171 views5 answers
How to install sqlite3 python
SQL
0 vote171 views1 answer
Sum value by month sql
SQL
10 votes167 views6 answers
Mysql delete duplicates
SQL
3 votes166 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote170 views1 answer
Difference between varchar and varchar2
SQL
0 vote161 views1 answer
Oracle sql count occurrences of value in column
SQL