TSQL Challenge 13 – Solution by Neeraj Mathur and other TSQL Heros

Introducing new testing levels with complex (tricky) data In the previous post , I had mentioned about the new (improved) evaluation process for the challenges. Brad Schulz is working very hard on leading the process to build the data (which I call ‘tricky...

TSQL Challenge 13 – Solution by Isham Hamin

Better and Stronger Evaluation Process One of the challenges we, The TSQL Challenge Team has, is to come up with a robust evaluation process. As we dig deeper and deeper into it, we realize that it is not as easy as we thought. We need to come up with...

TSQL Challenge 13 – Winning Solution by Jim Carter

We had a glitch in one of the automatic scripts that we use to evaluate the solutions and had to re-evaluate the solutions last night. After spending the whole night (and unlimited cups of coffee) evaluating and reviewing the different solutions, we have...

TSQL Challenge 11 - Solution by Brad Schulz

Brad Schulz Brad has been working with databases for 30 years. He was a Microsoft Visual FoxPro (VFP) MVP from 1994-2000, and has written articles for various VFP publications. He now devotes most of his time to SQL Server and is a moderator at the MSDN...

TSQL Challenge 11 - Solution by Peter Larsson

Peter Larsson Professional database developer since 2001. Started to use Microsoft SQL Server in 1993, and have been true since then. He mostly working with performance troubleshooting and database architecturing. How did Peter work on the challenge?...

TSQL Challenge 10 – Solution by Alejandro Mesa (Hunchback)

. Hunchback (or Alejandro Mesa) is is a Database developer at Bank of America.He has been working with SQL Server for almost 10 years by now, OLTP and OLAP. Lately he has been more dedicated to dimensional modeling, ETL, OLAP, and reporting services,...

TSQL Challenge 10 – Solution by Divya Agrawal

  Divya has an original solution based on XML data type methods and PIVOT operator to perform the required sort operation for this challenge. XML Data type is a great feature added in SQL Server 2005.  While XML methods can be used to solve...

TSQL Challenge 10 – Solution by Rob Farley

For this challenge #10, Rob comes with a very nice solution, he was also part of the winners in the TSQL Challenge #9 in July. Owner/Principal of LobsterPot Solutions, is a SQL MVP and MCT based in Adelaide, Australia where he runs the local SQL Server...

TSQL Challenge 9 – Solution by Syed Mehroz Alam

For the TSQL Challenge #9, Syed Mehroz Alam is again part of the winners. You can see its previous solutions for the TSQL Challenge #7 and TSQL Challenge #8 . Syed Mehroz Alam, living in Karachi, Pakistan, is primarily a developer focusing Microsoft technologies...

TSQL Challenge 9 – Solution by Rob Farley

For the TSQL Challenge #9 , Rob was one of the first to provide a very smart and simple solution. Owner/Principal of LobsterPot Solutions, is a SQL MVP and MCT based in Adelaide, Australia where he runs the local SQL Server User Group. He consults and...

TSQL Challenge 8 – Solution by Leonid Koyfman

Yesterday, we saw the solution from Syed Mehroz Alam and discovered how Syed used subqueries. Another winner of TSQL Challenge 8 is Leonid Koyfman . First of all, I would like to congratulate Leonid who is a faifthfull challenger and a many times winner...

TSQL Challenge 8 - Solution by Syed Mehroz Alam

Yesterday, we saw the solution for TSQL Challenge #8 by Matthieu Hodin . Another winner of TSQL Challenge 8 is Syed Mehroz Alam. First of all, I would like to congratulate Syed. Yes Syed, as you said: it’s a pleasure  to learn that the hard work...

TSQL Challenge 8 – Solution By Matthieu Hodin

For this TSQL Challenge #8 , Matthieu provides us a nice, readable and fast solution.       Matthieu Hodin is Project Manager at Wygwam , developper since he  got an HP48GX in hands (who remember?), and web developper since 2002. He...

TSQL Challenge 8 Winners

Thanks to all Challengers I would like to cheerfully thanks all challengers for their solutions to this challenge. It's the members of a community that grow that community. Information you are sharing here is the very heart of this learning community's...

TSQL Challenge 7 - Solution by Syed Mehroz Alam

Syed Mehroz Alam prensents us a nice solution using all the principles already described. As obvious, he’s solution is one of the sortests. But let’s present Syed berore running into it: Syed Mehroz Alam , living in Karachi, Pakistan, is primarily...