/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 vote142 views1 answer
Postgress append string in select
SQL
0 vote171 views1 answer
ORACLE PARSE STRING
SQL
4 votes154 views2 answers
Tables in sql
SQL
0 vote138 views1 answer
Get only one row in mysql
SQL
0 vote98 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
2 votes185 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote132 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote143 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote141 views1 answer
Primary key multiple colums
SQL
0 vote126 views1 answer
Create table employees oracle
SQL