Collapsing Consecutive Periods in Time Series Data Using RLE

How to Break Down Date Periods in SQL Server Using the Tally Table Technique