Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLUser4970
Starting Member
1 Post |
 Posted - 2012-06-08 : 11:55:54
|
| Hello,I am using SQL server 2008. Right now I have an existing query, but I want to apply it to a new table that I just created (with columns and data types already inserted). Any idea how to do this? Any help is greatly appreciated. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-08 : 11:59:02
|
| [code]INSERT INTO table (column1,column2,...)SELECT Column1,Column2,...FROM YourQuery[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Inserting a query into a table