SELECT SUM(LEN(P.Body COLLATE Latin1_General_BIN)) AS Cha...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  SUM(LEN(P.Body COLLATE Latin1_General_BIN)) AS CharacterCount
FROM PostsWithDeleted P
WHERE
  P.PostTypeId = 1 -- questions
  AND P.CreationDate  > DATEFROMPARTS(2022,11,30)
  AND P.CreationDate <= DATEFROMPARTS(2023,06,11)
;

Enter Parameters

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