Insert records returned in select

[vpekulas]

Is there a way to insert records that are returned by a select statement ?

I have 2 identical tables, each with the same structure, but different names. I want to query one table and insert the result into another one.

I'm using MS SQL. Thanks

"Taxes are the fees we pay for civilized society" G.W.

 

[PHV]

Try something like this:
INSERT INTO Table1 SELECT * FROM Table2 WHERE ...

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244