TSQL Challenges

TSQL Challenges intend to help you to test and enhance SET based querying skills using TSQL.





TSQL Challenges 16 – Accepted Solutions

This is to give a quick update to those of you who are eagerly waiting for the results of the previous challenges. All the solutions we have received so far for challenge 16 are listed at http://databasechallenges.com/SQLServer/TSQL/Challenge16/Submissions. A few submissions were rejected because they used #temp tables, table variables or local variables.

The list of solutions accepted for further processing are listed at http://databasechallenges.com/SQLServer/TSQL/Challenge16/accepted. If you see your solution in ‘all solutions’ but do not see it in ‘accepted solutions’ it means that your solution is rejected due to one of the reasons given above. If you think that your solution does not fall into the categories I mentioned earlier, and still not listed in ‘accepted solutions’ please let us know and we will double check what is wrong.

While the evaluation of TSQL Challenge 16 is still in progress, we started also the evaluation of Challenge 17. We will post the list of submissions for your review soon. As I had mentioned last week, we are using the new software for the evaluation and the evaluation process for the first couple of solutions will still be slow. However, we will catch up with the challenges soon and our goal is to publish the results of a challenge within 2-3 weeks of publishing it.

Comments

Ramireddy said:

Jacob,

I uploaded my solution of Challenge16 in media gallery, one week ago, the day that u asked to re-send the solutions, if we didnt find our in initial list.......I didn't figure my solution neither in all solution nor accepted solutions............

Can you please look into it???

# January 31, 2010 12:57 PM

Ramireddy said:

this is my solution...

beyondrelational.com/.../2880.aspx

# January 31, 2010 1:08 PM

Jacob Sebastian said:

@Ramireddy,

Thanks for pointing this out. We expected a few such issues because of the switching to the new software. We will add your solution to the list shortly.

# January 31, 2010 10:15 PM