I’m back from vacation in North Cape. What a spectacular place! During my vacation, my friend Itzik Ben-Gan has published a quiz on SQL Server Magazine based on a question that I’ve sent to him after that Timo Qvist - a participant to the Workshop I delivered in Stockholm in June on SQL Server 2008 – raised the question to me.
I had found the answer, but I thought that the question was intriguing because it needed some “out-of-the-box” thinking and a set-based approach – which I’m trying to teach to developers – and so it would be nice to put it into a quiz to see what other approaches and solution could be done to solve the problem.
Here you can find the quiz:
http://www.sqlmag.com/Articles/ArticleID/102689/102689.html?Ad=1
and here the solutions. Kudos to Steve Kass for being able to think “out-of-the-box” more then any other else, and find a solution where no solution seemed to be present!
http://www.sqlmag.com/Articles/ArticleID/102732/102732.html?Ad=1