Just looking at some resources on the web.
http://technet.microsoft.com/en-us/library/ms189798.aspx
This explains the RANK options that were talked about earlier in the topic - I think now this was a little misleading as does not give what you wanted. But could be useful thing to remember "That you can do it" - to store in the back of your mind.
Regards
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.