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...
The basic testing results of TSQL Challenge 79 - Finding the Islands is published and you can find it here .
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
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 .
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 .
The basic testing results of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals is published and you can find it here .
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