GAPS and ISLANDS in SQL Server

Sometimes you may want to identify continuous sequences of data while skipping over rows of "missing" data.  This is known as the Gaps and Islands problem and today we look at one solution for it on a dataset of date ranges using window functions.

Subscribe and turn on notifications to never miss a weekly video: https://www.seevid.ir/c/DataWithBer...

Running totals with Window functions:
How to Generate a RUNNING TOTAL in SQ...

Related blog post with example code:
https://bertwagner.com/2019/03/10/gap...

Follow me on Twitter:
Twitter: bertwagner

• #science_technology
• #sql_server
• #sql
• #gaps_and_islands
• #window_functions
• #sum_function
• #lag_function
• #row_number_function