Solutions to TSQL Challenge – Reoccurring VisitsCommented on: 4 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.
High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More