Just looking at some resources on the web.
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.
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.