SELECT --TOP 1000 CreationDate, LEN(Text)-LEN(REPLACE(Tex...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT --TOP 1000
--PostId AS [Post Link],
-- UserId AS [User Link],
CreationDate,
LEN(Text)-LEN(REPLACE(Text,'"Id"','"d"'))
--Text
FROM PostHistory
WHERE Comment = '101'
  AND CreationDate > DATEADD(year,-1,GETDATE())
  AND Text NOT LIKE '%GoldTagBadge%'
  AND Text NOT LIKE '%DuplicateApprovedByAsker%'
ORDER BY CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results