Quote Originally Posted by leinad31
Performance varies depending on how database, tables, indexes, and the data itself. There is no such thing as a one size fits all approach to writing efficient SQL.
True...plus the compiler, at least SQL 2005, sometimes has a mind of it's own.