0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

CREATE TABLE #CSQ (/*Site nvarchar(max),*/ Date date, [Count] int);
INSERT INTO #CSQ EXEC dbo.sede_ineachdb
@SQLCommand=N'
SELECT
  --Site = [$site name$],
  Date = EOMONTH(U.CreationDate),
  [Count] = COUNT(*)
FROM Users U
GROUP BY EOMONTH(U.CreationDate)
;',
@IncludeMetaSites=0;
SELECT [Date], SUM([Count])
FROM #CSQ
GROUP BY [Date]
ORDER BY [Date]
;

fork query

edited apr 12 anonymous

created apr 11 Aaron Bertrand