Adventure Works is a fictitious sample database that was created by Microsoft for educational and demonstration purposes. It is often used as a sample database in various Microsoft products and ...

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 session was open to any CRM and BI topic so I expected a lot of hard questions about data mining and the like but the topic of greatest interest turned out to be the CRM and SQL Server Reporting .