0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

with Date as (
    SELECT CAST('2012-6-20' as date) DateId
    UNION ALL
    SELECT DATEADD(day, 1, DateId)
    FROM Date
    WHERE DATEADD(day, 1, DateId) <= '2012-7-25'
    ) ,
    
    Comments2 as (
    SELECT Id,PostId,CONVERT(date, CreationDate) as cDate
    FROM Comments
    ) 
    
select 
Top 50
d.DateId, c.PostId, Count(c.Id) as CommentCount

from Date d LEFT JOIN Comments2 c

on d.DateId=c.cDate
where  d.DateId >= '2012-07-22' AND d.DateId <= '2012-07-25' 
group by d.DateId, c.PostId
order by d.DateId asc, Count(c.Id) desc

fork query

edited feb 3

created feb 2 anonymous