Hi

I quite like the exposition of the rownumber and over stuff.  Interesting.

What I would ask is whether the performance issues relating to the and(x is null or x = y) that were experienced in SQL2000 (ie knocking it down to a scan) have been resolved on 2005?

Cheers