TSQL Challenge 79 - Finding the Islands

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 02 Apr 2012 06:00:00 UT Indexed on 2012/04/06 5:37 UTC
Read the original article Hit count: 153

Filed under:

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.

SQL Monitor What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use
tool built for no-nonsense database professionals.
For effortless insights into SQL Server,
download a free trial today.

© SQL Server Central or respective owner