0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

SELECT TOP 1
    OwnerUserId,
    COUNT(*) AS PostCount,
    DATEPART(WEEK, CreationDate) AS Week,
    YEAR(CreationDate) AS Year
FROM
    Posts
GROUP BY
    OwnerUserId,
    DATEPART(WEEK, CreationDate),
    YEAR(CreationDate)
ORDER BY
    PostCount DESC

fork query

edited oct 21 jon.doe46078

created oct 21 anonymous