/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

1 vote192 views1 answer
ALL_TAB_PARTITIONS
SQL
7 votes249 views1 answer
Alter sequence set current value oracle
SQL
0 vote196 views1 answer
Java input type sql date
SQL
1 vote279 views1 answer
How to get alternate records from a table in sql
SQL
0 vote212 views1 answer
Oracle right characters
SQL
0 vote225 views1 answer
How to run mysql on terminal mac
SQL
0 vote435 views1 answer
Sql datum formatieren
SQL
39 votes300 views4 answers
Select duplicates in sql
SQL
0 vote207 views1 answer
Dbms_output sql developer
SQL
1 vote203 views1 answer
Oracle start job
SQL