Alternative to 740847

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

CREATE TABLE #CSQ (/*Site nvarchar(max),*/ Date date, [Count] int);
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]
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results