Coping sql database record

[Terry Blake]

Is there a way to copy a sql record(s)? Right now I just do a cfquery and then loop over <query>insert...</query> to create the new records. This works but there must be a better way.

 

Thanks for any help!

Terry