Q&A for professionals and students of engineering
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description select dateadd(mm,datediff(mm, 0, CreationDate),0), count(1) from Users group by dateadd(mm,datediff(mm, 0, CreationDate),0) order by 1; /*select top 200 dateadd(mm,datediff(mm, 0, CreationDate),0),CreationDate from Users;*/