/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

4 votes244 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote262 views1 answer
Sqlalchemy _in array sqlite
SQL
3 votes182 views1 answer
If 0 return null else return query mysql
SQL
0 vote222 views2 answers
Mysql select date from datetime
SQL
1 vote234 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
2 votes227 views1 answer
Set column to not null mysql
SQL
1 vote222 views3 answers
Sql server get week dates from week number
SQL
0 vote246 views1 answer
Mysql zerofill
SQL
0 vote241 views1 answer
Order child below the parent in mysqli
SQL
0 vote237 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL