THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

T-SQL quiz: a simple quiz with a an “impossible” solution!

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:

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!

Published Sunday, August 30, 2009 9:58 PM by Davide Mauri
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog


Privacy Statement