I have a database table with X number of fields.
I need to read all the records where “KEY=‘A’” and duplicate them with “KEY=‘B’”
preferably without having to list all the other myriad of fields
select all into a temp table create table tempwork as select * from original
alter the fieid using updates update tempwork set Key = 'B'
insert back to original by selecting all from the temp insert into original select * from tempwork
drop the temp drop table tempwork
yeah, thats what I ended up doing Thanks
did have to set the PK in the temp table to NULL to avoid constraint violations
that makes sense as well