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

Note that Oracle also offers an alternative syntax using the CONNECT BY construct, which we will not discuss here. A CTE can be thought of as a named temporary table within a SQL statement that is ...