/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 votes298 views1 answer
Rename stored procedure in sql server
SQL
0 vote292 views1 answer
Query for backup a database at another location in file system
SQL
0 vote275 views3 answers
Java hide mysql login credentials
SQL
0 vote261 views1 answer
Mysql grant user wildcard database
SQL
4 votes249 views2 answers
How to delete row in sql
SQL
0 vote274 views1 answer
Sql select random procentage from rows
SQL
1 vote267 views1 answer
Postgresql escape single quote
SQL
0 vote282 views1 answer
Order child below the parent in mysqli
SQL
3 votes260 views1 answer
Oracle apex call duration
SQL
3 votes279 views2 answers
Oracle privileges users
SQL