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 idea is taken from a problem discussed in the MSDN TSQL forum. The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date. For example, 01/

This blog about the practical solutions for the problems that SQL server DBA face in their day to day work...

Update: <br/> We added a new rule to the challenge.Rule 7. There will always be at least one part in each row of the input table.

The challenge idea is taken from a problem discussed in the MSDN TSQL forum. The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.

Microsoft .NET Framework 4 contains many new features building incrementally upon .NET Framework 2.0 and 3.0....

UPDATE: We have added one more rule. "The Interval column always starts at 1 and has no gaps."