Nice to see someone using LOGs. But I would trust your results more if you displayed them, instead of using the WHERE expected_result <> actual_result.

The problem I found was that...

Good stuff. Thanks for info - and the links others have supplied to asociated information is helpful too.

We have found #temp tables often significantly outperform derived tables in situations where...

Interesting article. I'm glad I always use the newer syntax. To the poster who said the problem was that the problem was not knowing which part of the where to...