It is interesting it doesn't work with ROW_NUMBER() function , so how it works on the other way!? :w00t:
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]