Solutions to TSQL Challenge – Reoccurring VisitsCommented on: 2 years ago
(July 25, 2012)
Late to the party but this beats Peso's #6 with a very simplistic FULL join:
TOP (SELECT DATEDIFF(d,MIN(dt),MAX(dt))+1 FROM dbo.DailyVisits)
n = DATEADD(d,...
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More