TSQL Challenge 82 - Find elements that uniquely make up a group

The challenge is to find the Tax Code based on Price. There is a table called "LineItems" that have Invoice Number and Price. There is another table "Sales" that contains Invoice Number, Amount and Tax Code. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.

http://beyondrelational.com/puzzles/challenges/116/find-elements-that-uniquely-make-up-a-group.aspx

TSQL Challenge 79 – Basic Testing Results

TSQL Challenge 79 – Basic Testing Sandbox

Just published a sandbox for the basic testing of TSQL Challenge 79 - Finding the Islands. http://beyondrelational.com/puzzles/tsql/challenges/79/basic-testing-sandbox.aspx

TSQL Challenge 78 – Results of Tricky Testing

We have completed the ‘tricky testing’ of TSQL Challenge 78 - Parse single field into multiple fields and the result is published here. The data used for the tricky testing is given here.

TSQL Challenge 78 – Tricky Data

We are about to start the logic testing of TSQL Challenge 78 - Parse single field into multiple fields. We have created a sandbox for the tricky testing and you can find it here.

TSQL Challenge 77 – Basic Testing Results

TSQL Challenge 77 – Basic Testing Sandbox

Just published a sandbox for the basic testing of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals. http://beyondrelational.com/puzzles/tsql/challenges/77/basic-testing-sandbox.aspx

TSQL Challenge 78 – Basic Testing Results

TSQL Challenge 78 – Basic Testing Sandbox

Just published a sandbox for the basic testing of TSQL Challenge 78 - Parse single field into multiple fields. http://beyondrelational.com/puzzles/tsql/challenges/78/basic-testing-sandbox.aspx

TSQL Challenge 74 - Find the expiring quantity of material

The challenge is to create a query for a report that shows expiring material.

http://beyondrelational.com/puzzles/challenges/108/find-the-expiring-quantity-of-material.aspx

TSQL Challenge 73 - Implement Word Wrapping in TSQL

The challenge is to wrap long text sequences to a specified overall width (wrap position) - similar to columns in a newspaper.

http://beyondrelational.com/puzzles/challenges/107/implement-word-wrapping-in-tsql.aspx

TSQL Challenge 72 – Basic Testing Sandbox

Just published a sandbox for the basic testing of TSQL Challenge 72 - Calculate the Payroll Hours of Employees. http://beyondrelational.com/puzzles/tsql/challenges/72/basic-testing-sandbox.aspx

TSQL Challenge 71 – Basic Testing Results

TSQL Challenge 72 - Calculate the Payroll Hours of Employees

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.

http://beyondrelational.com/puzzles/challenges/106/calculate-the-payroll-hours-of-employees.aspx

TSQL Challenge 71 – Basic Testing Sandbox

Just published a sandbox for the basic testing of TSQL Challenge 71 - Play mangled words game in TSQL. http://beyondrelational.com/puzzles/tsql/challenges/71/basic-testing-sandbox.aspx