In this example, Transact-SQL will create a new table with all ... of two separate queries with the UNION keyword. Build a SELECT statement similar to the following in the Query window: SELECT ...

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?