The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService. You need to check each row in the table to see if that particular product has the d

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

Added.
Thanks for pointing it out.

This challenge is to generate a game schedule based on the teams given in a table. The key point is each team has to play with another team in each round of the games.

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

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/

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

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