/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 vote125 views1 answer
Oracle list chain steps
SQL
0 vote145 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
1 vote127 views1 answer
How to use a trigger to validate input data
SQL
1 vote147 views1 answer
Oracle sql first day of year
SQL
0 vote141 views2 answers
Temp tables in sql server
SQL
1 vote135 views1 answer
Primary key with prefix sql
SQL
9 votes168 views3 answers
Date format in sql
SQL
0 vote129 views1 answer
Mysql select where text contains
SQL
3 votes145 views4 answers
Show databases in sql server
SQL
0 vote131 views1 answer
Oracle index hint multiple tables example
SQL