/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 vote304 views1 answer
Oracle remove line breaks
SQL
3 votes293 views1 answer
Select nextval from sequence sql
SQL
1 vote311 views1 answer
Mysql check if string contains comma separated
SQL
0 vote282 views2 answers
Cascade syntax in sql
SQL
1 vote308 views1 answer
Convert epoch to date in sql server
SQL
36 votes306 views6 answers
Rename table sql
SQL
17 votes287 views4 answers
Set mysql Password
SQL
0 vote311 views1 answer
Plsql find location of procedure
SQL
9 votes319 views3 answers
Date format in sql
SQL
1 vote290 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL