I want to copy many rows from a table and re-insert them into the same table but changing one of the fields.

1) select * from curve_def_derived_sec
where curve_id = 362
and def_datetime > '09 Jan 04'

2) Now I want to insert the results from the above query back into table curve_def_derived_sec but change the results so that curve_id = 264

Note the curve_id is a primary key.

Aside from doing an insert for every line with the values, does anyone know of a mass update.

If you want only7 to change the Curve_id:

Update curve_def_derived_sec
Set curve_id = 264
where curve_id = 362
and def_datetime > '09 Jan 04'

Or, if you want to insert new rows:

Insert << Field List, including curve_if>>

into curve_def_derived_sec

Select <<all fields but curve_id>>, 362

from (select * from curve_def_derived_sec
where curve_id = 362
and def_datetime > '09 Jan 04')

Does it answer your question?

-------------------------------------------------------------------

I want to copy many rows from a table and re-insert them into the same table but changing one of the fields.

1) select * from curve_def_derived_sec
where curve_id = 362
and def_datetime > '09 Jan 04'

2) Now I want to insert the results from the above query back into table curve_def_derived_sec but change the results so that curve_id = 264

Note the curve_id is a primary key.

Aside from doing an insert for every line with the values, does anyone know of a mass update

Cheers, exactly what I needed.