How NOT to Select Records

Apparently in his version of SQL Server, WHERE clauses only work on Temp tables...
«September»
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789