Number of edits per week

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT 
---https://stackoverflow.com/questions/1267126/get-the-week-start-date-and-week-end-date-from-week-number
  DATEADD(dd, -(DATEPART(dw, CreationDate)-1), CAST(CreationDate AS Date)) [WeekStart],
  COUNT(DISTINCT RevisionGUID) AS Count
FROM PostHistory
WHERE (CAST(CreationDate AS Date)>= '##Date1?2021-01-01##') AND (CAST(CreationDate AS Date)<= '##Date2?2023-01-01##')
GROUP BY DATEADD(dd, -(DATEPART(dw, CreationDate)-1), CAST(CreationDate AS Date))
ORDER BY DATEADD(dd, -(DATEPART(dw, CreationDate)-1), CAST(CreationDate AS Date))

Enter Parameters

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