Congratulations to the Winners of TSQL Challenge 13!
TSQL Challenge #13 was really interesting and several participants mentioned that they really enjoyed solving the problem. We received a large number of solutions, almost all of them were correct and well written. It was very interesting to see how many different ways exist to solve a given problem using TSQL. The evaluation team spent a lot of time testing each solution and finally came up with the three winning solutions.
The Challenge
The challenge is to break a batch of invoices into groups that are not more than 10 rows, without splitting a single invoice into two groups. See the challenge description for the details of this challenge.
And the Winners are …
Here are the winners of TSQL Challenge #13.
In addition to the regular winning solutions, we would like to present a "featured solution" by Brad Schulz from TSQL Challenge Team. Brad presents a very interesting solution which performs as good as the other solutions, but handles a number of exceptional cases which are not included in the sample data provided with the challenge.
Please join the TSQL Challenge Team to congratulate the winners. We will publish the winning solutions in the next few days.
Did You Try To Solve TSQL Challenge #17 ?
Please note that TSQL Challenge #17 will close on 30th November 2009. This challenge aims to test your SET based query writing skills by presenting a problem where you need to write a query that generates the HTML code for turning some of the keywords in a column into hyper links. Read More »
Did you Receive TSQL Challenges News Letter?
We are coming up with a bi-weekly news letter to keep you updated about what is happening with TSQL Challenges and share with you some of the interesting information we collected during the week (such as interesting SQL Server blogs, white papers etc). The first newsletter went out yesterday (23 Nov 2009) and we had a few ‘first time glitches’, as all of you would expect. An online version of the news letter can be found here. If you are a member of beyondrelational.com, you will get a copy of the news letter by default. If you are not, we would encourage you to Sign up here to get a copy of the bi-weekly news letter.
Did You Take A Look At TSQL Challenge Badges?
Thank you for supporting TSQL Challenges. We have created a number of badges for those of you who had been supporting us continuously. Feel free to use them on your blogs, websites, email signatures etc. Read More »