Database Challenges

TSQL Challenge 13 - Break a batch of invoices into multiple parts based on rules

See TSQL Challenge #13 for a detailed description of this challenge. This task involves breaking a batch of invoices into smaller groups of not more than 10 rows each, without breaking a single invoice into two groups.

The current status of this challenge is Closed, however, if you have a better solution, we will be glad to review it and publish it. To submit a solution, see the Submission Guidelines

Solutions

We received a large number of submissions for TSQL Challenge 13. We would like to thank every one for taking interest in TSQL Challenge 13. All the entries we received so far are online and you can see them here.

Evaluation Process

We evaluated the solutions using our three stage evaluation process. First, all the solutions went through the Basic Testing. You can find the data used for the basic testing here and take a look at the solutions that succeeded.

Solutions that passed the basic testing went through a Logic Testing where the solutions were tested against a set of tricky data.
You can find the data used for the logic testing here and you might find the solutions that succeeded very interesting.

Solutions that passed the Logic Testing went through the final LoadTesting phase where the solutions were tested against a large data set. You can find the results of the load testing here.