Aurelien   already closed the initial winners of the TSQL Challenge 5. He's solution for this challenge is a nice GROUP BY WITH ROLLUP one.   Aurelien Verla is Online Strategies Team Manager at Wygwam. Web Developer since 10...

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...

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...

Submit A Solution The Context You have done some Sql Server development tasks for a small company that has one Sql Server with several bases. Before you leave, as they will not have any dba to monitor databases, they ask you to write a simple script to...

To be able to connect better with the admirers of TSQL Challenges, we have been working on creating our workspace on a number of social networking websites/applications. Many thanks to my friend Rui , who is very passionate about TSQL Challenges and is...

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...