View Single Post
  #3 (permalink)  
Old March 7th, 2009, 04:50 PM
Old Pedant Old Pedant is offline
Friend of Wrox
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts

ummm...INSERT requires that the table you are INSERTing into already exists. So you'd have to figure out how to run a CREATE TABLE first.

What about just using SELECT INTO ???

The basic format is

SELECT list, of, fields
INTO brandNewTableName
FROM ....

If you can just manage to work "INTO xxxx" into the right place in your existing SQL, you might be done.
The Following User Says Thank You to Old Pedant For This Useful Post:
TComfort (March 9th, 2009)