Q&A for scientists using computers to solve scientific problems
--declare @start datetime = ( --select top 1 dateadd(day, datediff(day, getdate(), CreationDate), getdate()) --from Posts --group by datediff(day, getdate(), CreationDate) --having count(*) >= ##betathreshold?10## --order by datediff(day, getdate(), CreationDate) --); declare @stop datetime = ( select top 1 dateadd(day, datediff(day, getdate(), CreationDate), getdate()) from Posts group by datediff(day, getdate(), CreationDate) having count(*) >= ##betathreshold## order by datediff(day, getdate(), CreationDate) desc ); declare @start datetime = dateadd(month, -4, @stop) select dateadd(week, datediff(week, @start, CreationDate), @start) "Week of", --vt.Name, CASE WHEN IsAnonymous = 1 THEN 'Anonymous '+vt.Name ELSE 'Registered '+vt.Name END "Vote Type", count(*) "Daily Average" from PostFeedback join VoteTypes vt on vt.Id = VoteTypeId where CreationDate between @start and @stop --and IsAnonymous = 0 group by datediff(week, @start, CreationDate), vt.Name , IsAnonymous order by datediff(week, @start, CreationDate), count(*) desc