/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 vote365 views1 answer
Insert set mysql
SQL
0 vote367 views1 answer
Postrgres trunc
SQL
0 vote354 views1 answer
Allow external access to mysql
SQL
0 vote290 views2 answers
Jupyter notebook connect to database
SQL
1 vote389 views3 answers
Date_add mysql
SQL
2 votes372 views1 answer
Merge firstname and lastname in sql oracle
SQL
1 vote394 views1 answer
Oracle create program if not exists
SQL
3 votes334 views3 answers
Stop mysql service ubuntu
SQL
3 votes363 views1 answer
Oracle failed login attempts
SQL
0 vote355 views2 answers
How to type a blank discord messgae
SQL