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?

BR><BR>Anyway I could do another select query from tbl_ContractedEmployees and then INTO #Results.<BR><BR>However, some of our employees work for our company 40 hours a week and also put in extra ...