/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 vote179 views1 answer
Difference between min and max date sql
SQL
0 vote181 views1 answer
Find invalid datetime field
SQL
0 vote175 views1 answer
Char vs varchar2 in sql
SQL
0 vote199 views1 answer
Frename oracle
SQL
17 votes177 views4 answers
Show tables sql server
SQL
6 votes226 views1 answer
Identify primary key in oracle table
SQL
0 vote203 views3 answers
Condition in count sql
SQL
1 vote187 views2 answers
Foreign key set 0
SQL
2 votes183 views1 answer
Compare date in sql
SQL
-1 vote238 views1 answer
Mysql coalesce
SQL