I am very glad to announce the winners of TSQL Challenge 17 . There were many solutions that passed the basic testing . However, a major part of them failed the logic testing for a number of different reasons. The data we used for the logic testing is...
We are very glad to announce the winners of TSQL Challenge 12 today. We would like to thank all the participants of TSQL Challenge 12 and would like to congratulate the winners: Greg Holecek Syed Mehroz Alam Matthieu Hodin We will be posting the winning...
Arnaud Lhopiteau is a MCSD .NET & Senior developer at Alltitude.com, his father introduced him to database systems with R:Base in late 80’s . He loves to take care of his family, read Joe Celko’s book, smoke pipe and drink tea. Currently he...
Cleber is a new challenger. He provides us a nice and readable solution using UNION and CROSS JOIN. Cleber Martins works for ACI Worldwide as a Sr. Business Solutions Analyst for the Risk products. Cleber is based in Brazil and has 8 years of experience...
Again there were a lot of participants for this challenge , and a lot of different solutions. Regarding all these solutions this is the short list of the winners we choose for this challenge: Arnaud Lhopiteau Arnaud Lhopiteau is a MCSD .NET & Senior...
Aurelien is a new challenger that closes the initial winners of the TSQL Challenge 5. Aurelien Verla is Online Strategies Team Manager at Wygwam. Web Developer since 10 years, his first approach with databases systems was Access ! MVP around ASP.NET Platform...
Friedrich Paul is another many-times-winner of the TSQL Challenges. He uses like Leonid only one CTE with the same split parsing recursively mechanism . This solution is very goods in terms of code optimization (even if it is too much compressed for a...
Divya is a new challenger that sends us a very interesting solution. She show us that it can be done without CTE in one very short and simple query. We really enjoyed her solution not only because it is a completely different solution but also because...
There were a lot of different solutions for this challenge but globaly the key point to release the split in line in an unique query was to use CTEs. As most people send us valuable queries with CTEs, we took in consideration also other notation points...
So far, we have seen two solutions for TSQL Challenge 4 . Leonid wrote the shortest code and Pinal created the second shortest code. The entry submitted by Antoine won the third place for this challenge. This is the second time Antoine winning...