In SSIS Transactions, Not Supported does not always work the way we expect it to. Let us see what is the case and how do we overcome the scenario....

The basic testing results of TSQL Challenge 79 - Finding the Islands is published and you can find it here. ......

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......

The basic testing results of TSQL Challenge 78 - Parse single field into multiple fields is published and you can find it here. ......

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....