0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

;with x as
(
  select cast(cast(datepart(year, CreationDate) as varchar) + '-' + cast(datepart(month, CreationDate) as varchar) + '-01' as datetime) as period,
    *
  from users
)
select period, count(1)
from x
group by period
order by period

fork query

edited feb 9 17 Izabel

created jan 12 17 Eugene.Gubenkov