sql server (alternate): What is the easiest way to copy a record from one table to another (with
identical structure)?

Regards

You mean into a new table? if so you can use select * into newtable from
oldtable (input your where statement)

To input into an existing table

insert into table1 select * from table2 (insert where statement)

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***