SQL To Loop thru Table and set a calc value on every record

[williadn48]

How do I loop thru a table and set a calculated value on every record?

Do While Not EOF
Read First Record
set intField = DateDiff(Second,Date1Fld,Date2Fld)
Next Record
Loop

Syntax please.
Thanks.

 

[Lamprey13]

UPDATE <table Name>
SET <field name> = DATEDIFF(SECOND, Date1, Date2)

 

[SQLSister]

Lamprey is right - use a set-based stament such as he/she provided. Never loop through data; get the whole idea of looping through data out of your head - it is a very bad practice.

Actaully there are few rare cases where looping is necessary but at the beginner level you should never ever do a loop. Updates, inserts and delees can all be done more efficiently without looping.

Questions about posting. See faq183-874