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?

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 ...

BR><BR>Is it possible to create a temp table on a remote server ... to my server to perform some more work with.<BR><BR>Also the statement is too large to fit in an open query command (the ...