/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

5 votes128 views1 answer
Oracle drop index if exists
SQL
0 vote104 views1 answer
Sql select all tables from database change url
SQL
13 votes113 views3 answers
Sql online code
SQL
3 votes158 views1 answer
Oracle cannot access v$session
SQL
0 vote124 views1 answer
How to to get time in sql
SQL
1 vote108 views1 answer
Alter add syntax
SQL
0 vote124 views1 answer
Sql bild in function
SQL
1 vote128 views1 answer
Oracle transaction rollback not working
SQL
0 vote135 views1 answer
Sql show founctions
SQL
0 vote148 views1 answer
Sql alternative to max statement
SQL