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. Leonid not only writes regularly excellent solutions...
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 has paid off! Syed already won the TSQL Challenge...
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 is interested in "data" and "interface"...
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 value! The Challenge So, challenge 8 was...
Submit A Solution Welcome to TSQL Challenge 8! This challenge is more about processing HIERARCHIES. SQL Server 2008 introduced a new data type HIERARCHYID which is pretty good for processing hierarchies. However, the problem explained in this challenge should be fixed without using the HIERARCHYID data...