0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select 
top 1000
DATEADD(MINUTE, -1 * DATEPART(MINUTE, CONVERT(SMALLDATETIME, CreationDate)), CONVERT(SMALLDATETIME, CreationDate)) as [Hour],
COUNT(1) as [Number]
from Comments
where
id > 2205000 and
Text like '%programmers.stackexchange.com%'
or Text like '%programmers.se%'
group by DATEADD(MINUTE, -1 * DATEPART(MINUTE, CONVERT(SMALLDATETIME, CreationDate)), CONVERT(SMALLDATETIME, CreationDate))
order by DATEADD(MINUTE, -1 * DATEPART(MINUTE, CONVERT(SMALLDATETIME, CreationDate)), CONVERT(SMALLDATETIME, CreationDate)) desc

fork query

edited mar 27 13 jon.doe10212

created mar 27 13 anonymous