/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 vote114 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote99 views1 answer
Oracle for loop on list
SQL
1 vote116 views1 answer
Psql import backup file for windows
SQL
5 votes113 views1 answer
Oracle list days between two dates
SQL
10 votes89 views1 answer
Oracle dependency
SQL
0 vote73 views2 answers
Delete the last item in a table sql
SQL
0 vote100 views1 answer
Psql check if value in array
SQL
4 votes129 views2 answers
Dbms output
SQL
3 votes122 views3 answers
Update con select postgresql
SQL
0 vote115 views2 answers
How covert into int in maria db
SQL