creating tables from other tables 1

[dmine]

in oracle SQL a statement such as "create table temp as select * from old_table" works fine and creates a table called temp, but the same statement does not execute in MS SQL Server. any solutions? i need to create a table through a select query, such as the one explained. please post a answer soon. thanks!

also when i try to import data into excel from SQL server, it only works for tables, but the program simply hangs when i try to import data from a view. please help!

 

[perfectchaoss]

Dmine,
Create a view with the select statement you want. Then import that view into a table using data transformation services (DTS)
jf

 

[perfectchaoss]

Sorry, I guess you already tried that. The only other solution i can think of is using the DTS and then instead of selecting "Copy table(s) and view(s) from the source database"
Choose the option button "Use a query to specify the data transfer" Then put your SQL statement in thier
jf

 

[vadimg]

dmine, correct syntax:

SELECT col1, col2, col3
INTO temp
FROM old_table