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.
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
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
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
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
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
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
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
We have completed the ‘tricky testing’ of TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2 and the result is published here. The data used for the tricky testing is given here.