/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 vote274 views1 answer
Add column to table with default value plsql
SQL
0 vote299 views1 answer
Mysql extract day from date leading zero
SQL
0 vote309 views1 answer
Doctors appointment
SQL
0 vote290 views1 answer
Mysql match in serialized data
SQL
0 vote287 views1 answer
MySQL import data from large CSV file
SQL
7 votes363 views2 answers
3rd height salary sql
SQL
2 votes270 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote271 views2 answers
Select limit ms sql
SQL
0 vote267 views1 answer
Stop psql server windows
SQL
0 vote323 views2 answers
Identity syntax in sql
SQL