Posted by Plamen Ratchev on 02/20/07 16:40

To insert into a table that already exists you use INSERT INTO. In your case
it will be something like this:

INSERT INTO NewTable (OrderID, CustomerID)
SELECT OrderID, CustomerID
FROM Source1

This assumes table NewTable already exists. If the table does not exist you
can create it with SELECT INTO like this:

SELECT OrderID, CustomerID
INTO NewTable
FROM Source1

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Restore SQL DB with correct logical file names
• Prev in forum: Re: Improving performance
• Thread view: Re: simple SQL question to insert records in an existing table - Newbie

[Reply to this message]