I am really glad to announce that my solution to TSQL Challenge 7 was chosen among the winners. I briefly described my solution in this post. For result, have a look at http://beyondrelational.com/blogs/tc/archive/2009/06/17/tsql-challenge-7-winners.aspx, and get prepared for the upcoming challenges at http://beyondrelational.com/blogs/tc/default.aspx