Solutions to TSQL Challenge – Reoccurring VisitsCommented on: 3 years ago
(July 19, 2011)
Solution#1, used idx_visitor_dt.
;with Calendar as
select @from dt
select DATEADD(DAY, 1, dt)
where dt < @to
, isnull(todayNum, 0) numvisitors
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.