Q&A about the site for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
WITH groups(date, grp) AS ( SELECT DISTINCT CAST(CreationDate AS DATE), dateadd(day, -DENSE_RANK() OVER (ORDER BY CreationDate), CreationDate) AS grp FROM Posts WHERE OwnerUserId = ##UserId## ) SELECT COUNT(*) AS consecutiveDates, MIN(date) AS minDate, MAX(date) AS maxDate FROM groups GROUP BY grp ORDER BY 1 DESC, 2 DESC