So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?

Use temp tables to improve ... function as a column in a SELECT query. SQL Server Enterprise offers “partitioning,” which allows you to split database tables into multiple partitions.

I tried this in the past, but didn't have any luck.<BR><BR>Is it possible to create a temp table on a remote server?<BR><BR>Situation:<BR><BR>I have to run a group of queries against a remote server.

Here's a SQL statement that uses the values in the temporary table to retrieve rows from one table and insert them into another table: Insert Into Employees (FirstName, LastName, Status) Select ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...