/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 vote175 views3 answers
Constraint sql
SQL
0 vote150 views1 answer
Oracle synonym procedure dblink
SQL
0 vote159 views1 answer
Como hacer una consulta en sql
SQL
0 vote144 views1 answer
C# mysql update statement set value to null
SQL
0 vote141 views1 answer
Inner joint
SQL
6 votes132 views5 answers
Get current date sql
SQL
0 vote148 views1 answer
Postgres 11 add primary key
SQL
1 vote155 views1 answer
Get create table query existing table mysql
SQL
0 vote183 views1 answer
Jooq replace
SQL
57 votes646 views6 answers
Sql alter table
SQL