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?

The SELECT statement tells the query optimizer ... I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple. Every table that you want ...

SELECT options refine results As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. These options ...