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