I need to:
1. select * from dbtable where empkey = 24
2. Change empkey to 9999
3. Insert the NEW employee 9999 in the database with employee 24's data

Your thoughts? I know I can do this in VB easy but it is bugging me that I cant think of how to do it in sql.