TSQL Challenge 79 - Finding the Islands

,

             TSQL Challenge 79 - Finding the Islands

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.

http://beyondrelational.com/puzzles/challenges/113/finding-the-islands.aspx

Rate

Share

Share

Rate