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,...
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
An in-depth look at some of the concerns involved with enabling/disabling entire SQL Server jobs based upon whether they should be run, or not—and then look at options for addressing those concerns....More