Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Counting distinct periods of consecutive days RE: Counting distinct periods of consecutive days
a.myasnikov
SSC Enthusiast
Points: 147
More actions
October 6, 2012 at 6:31 am
#1546407
Here's a good reference article.
Group Islands of Contiguous Dates (SQL Spackle)
http://www.sqlservercentral.com/articles/T-SQL/71550/