TSQL Challenge 21 - Winners

Here are the winners of TSQL Challenge 21

Muhammad AlPasha	View Profile\|Solution	10 SQL Stars
Michael Lewis	View Profile\|Solution	9 SQL Stars
leonid koyfman	View Profile\|Solution	8 SQL Stars
regan wick	View Profile\|Solution	7 SQL Stars
Mueller Lutz	View Profile\|Solution	6 SQL Stars
Arumugam Thiraviam	View Profile\|Solution	5 SQL Stars
Pavel Krticka	View Profile\|Solution	5 SQL Stars
Philippe Pimenta	View Profile\|Solution	4 SQL Stars
meierruth michael	View Profile\|Solution	3 SQL Stars
leigh waldie	View Profile\|Solution	2 SQL Stars
Ruchay Sohawan	View Profile\|Solution	1 SQL Stars

Can you beat these solutions?

Do you think you can come up with a better solutions? If you have a better performing query, Send us your solution. See this page to view the performance comparison of winning solutions.