The third form of the CREATE TABLE statement stores the results of any query-expression in a table and does not display the output. It is a convenient way to create temporary tables that are subsets ...

I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.Now the resulting data set will be about 10,000 records taken from ~ 8 tables.I can ...

Just use an sql INSERT statement, I guess.<BR><BR>I would recommend linking the table, copying it, then deleting the link if you really don't want the link there.