What is new with TSQL Challenges ‘ TSQL Challenges Team’ is working very hard to take this series to the next level. As part of this process, we have redefined the goal and structure of TSQL Challenges. Goal The goal of TSQL Challenges is to help people...
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 --------- -- ----------------------- --------------- ----------- 1 2009-03-23...
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...