Q&A for people looking to bypass life's everyday problems with simple tricks
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description select x, y, sum(y) over (order by x) z, sum(y) over (order by x rows between unbounded preceding and 1 preceding) g, round(y*100/sum(y) over (order by x rows between unbounded preceding and 1 preceding),2) k from ( select dateadd(mm,datediff(mm, 0, CreationDate),0) as x, count(1) as y from Users group by dateadd(mm,datediff(mm, 0, CreationDate),0) ) as w ; /*select top 200 dateadd(mm,datediff(mm, 0, CreationDate),0),CreationDate from Users;*/