Alternative to 740847

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

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 main site
loading Hold tight while we fetch your results