That's the approach I would up taking, thanks to a very elegant solution proposed by someone on another forum.

http://stackoverflow.com/questions/8831059/difficult-t-sql-programming-task

Thanks to all who replied!