What I want to do is:

first: copy one record from a table with certain creteria
second: just update two fields (these two fields are part of the key)
third: insert this new record into the same table

This talbe has more than 100 fields. (yeah, I know it sounds ridiculous that the table has more than 100 fields, but this is a very complicated system and that's how the thing works here.)

can somebody please show me how to write the query? If you could provide me with a sample example, that will be great!