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

I spent a lot of time reviewing all the solutions and regarding the key points of our current notation for the challenge this is the list of the winners: Leonid Koyfman which is a many times winner of the challenge and provide as usual a clean and very...

Submit A Solution The context For this challenge, you will have to analyse logs on the web server of your company. Here is the sample data you have to work with: ID VisitDate Page NbVisitors --------- -- ----------------------- --------------- ------...

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

Yesterday, we saw the solution for TSQL Challenge 4 by Leonid Koyfman . Another winner of TSQL Challenge 4 is my MVP friend Pinal Dave . Pinal used a very interesting logic in his solution. What I find very interesting with these challenges is that, it...

After scanning through the entries whole night, I have identified the best solutions for TSQL Challenge 4 . Since the challenge is to write the shortest TSQL Code, I have identified the entries that produced the correct result and sorted them by the length...