Subject Which way is best...
Author Michael Vilhelmsen

According to my earlier postings, I would like to know which way is best.

I have a table, containing some 4 mill. records.
Each records has several varchars, date, numeric and integer fields.
I have to insert around 300.000 more, which will be almost identical
to some other 300.000 except for 1 field.

What I do now is

Fields I need
from table
some condition

Then I iterate through to dataset and insert 1 record for each record.

How do I do that the best way ?