The evaluation of TSQL Challenge 28 is completed and here is the list of winners. See this page to view the performance comparison of winning solutions. Please join us to congratulate the winners!
We have created a basic draft of the performance test data for TSQL Challenge 28 . The test data is created by replicating the basic testing data. You can find the script here . If you have any suggestion to improve it or got a better script, let us know.
We have completed the ‘tricky testing’ of TSQL Challenge 28 and the result is published here . The data used for the tricky testing is given here .
We are about to start the logic testing of TSQL Challenge 28 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will start the tricky testing by tomorrow.
The basic testing results of TSQL Challenge 28 is published and you can find it here .
Just published a sandbox for the basic testing of TSQL Challenge 28 . http://beyondrelational.com/tc/challenge28/basicsandbox/default.aspx
The list of TSQL Challenge 28 solutions that passed the initial screening is published here . If you spot anything wrong with the listing, let us know.
This is a challenge to SELECT TOP N articles from each category from a SQL Server 2000 database. http://beyondrelational.com/puzzles/challenges/32/select-top-n-articles-from-each-category-from-a-sql-server-2000-database.aspx