I recently had this question, and because I'm using SS2K, couldn't use CTEs. Thanks to this terrific forum, I was provided with a very nice solution that doesn't rely on CTEs or row numbers. Check out this link

http://www.sqlservercentral.com/Forums/Topic462350-373-1.aspx#bm462366

Mattie