0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT COUNT(*), CAST(YEAR(CreationDate) AS VARCHAR(4))+ '/' + CAST(MONTH(CreationDate) AS VARCHAR(2))
FROM POSTS
GROUP BY CAST(YEAR(CreationDate) AS VARCHAR(4))+ '/' + CAST(MONTH(CreationDate) AS VARCHAR(2))

view current version

edited nov 3 17

created nov 3 17 Kalle.Viiri