beyondrelational.com



Browse by Tags

All Tags » TSQL-Challenge-Answer (RSS)
TSQL Challenge 17 – Winners
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...
TSQL Challenge #12 – Congratulations to the winners!
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...
TSQL Challenge 6 - Solution by Arnaud Lhopiteau
  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...
TSQL Challenge 6 - Solution by Cleber Augusto Martins
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...
TSQL Challenge 6 Winners
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...
TSQL Challenge 5 - Solution by Aurelien Verla
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...
TSQL Challenge 5 - Solution by Friedrich Paul
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...
TSQL Challenge 5 - Solution by Divya Agrawal
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...
TSQL Challenge 5 - Solution by Leonid Koyfman
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...
TSQL Challenge 4 – Solution by Antoine Gémis
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...
Copyright © Beyondrelational.com