Mike Is there any criteria for the records the customer wants to use?
Could you something along the lines of ... Select into newTable >From oldtable Where customer record = somecriteria? What database are you using? KOla >> -----Original Message----- >> From: Mike [mailto:[EMAIL PROTECTED] >> Sent: 05 July 2004 15:45 >> To: [EMAIL PROTECTED] >> Subject: [ cf-dev ] Urgent: Moving Data from one table to another >> >> >> I am trying to put in a bit of functionality into a very old app and >> it's a nightmare. >> >> Here's the scenario: >> >> - One Master Table with all records >> - Customer chooses groups of records they want to use which is then >> transported to another table for action >> >> What I am trying to do is find the quickest and most efficient way of >> transporting those records between the master and child table. Also the >> records that could be chosen could be anything from 100 - 50000 records. >> >> I have thought of a couple of ways of doing it involving arrays and sql >> inserts but didn't know if there was a way that sql could do it from a >> stored procedure (Still learning SQL at the moment) >> >> Any help would be gratefully received. >> >> Cheers >> >> Mike >> >> >> >> >> >> -- >> These lists are syncronised with the CFDeveloper forum at >> http://forum.cfdeveloper.co.uk/ >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> CFDeveloper Sponsors and contributors:- >> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by >> activepdf.com* >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >> proworkflow.com* >> *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
