Re: Copy Or Transfer Selected Records From One Table To Another Table?

2004-12-13 Thread Dave Carabetta
On Mon, 13 Dec 2004 12:36:51 -0600, Nick Baker [EMAIL PROTECTED] wrote: What is the most efficient way to copy or transfer selected records from one table to another table with the same structure?. I.e., all records within a certain date range. Select and Insert seems be a very laborious

Re: Copy Or Transfer Selected Records From One Table To Another Table?

2004-12-13 Thread Joe Rinehart
selected records from one table to another table with the same structure?. I.e., all records within a certain date range. Select and Insert seems be a very laborious method. Thanks, Nick ~| Special thanks to the CF

Copy Or Transfer Selected Records From One Table To Another Table?

2004-12-13 Thread Nick Baker
What is the most efficient way to copy or transfer selected records from one table to another table with the same structure?. I.e., all records within a certain date range. Select and Insert seems be a very laborious method. Thanks, Nick

Re: Copy Or Transfer Selected Records From One Table To Another Table?

2004-12-13 Thread Greg Morphis
I'm not about other DBs but INSERT INTO TableA SELECT * FROM TableB works fine in Oracle On Mon, 13 Dec 2004 12:36:51 -0600, Nick Baker [EMAIL PROTECTED] wrote: What is the most efficient way to copy or transfer selected records from one table to another table with the same structure?. I.e