Search edit summary and group them

0

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for a word in the Edit summary, also can check by time.

Ask Ubuntu

Q&A for Ubuntu users and developers

DECLARE @p_date DATETIME
 SET    @p_date = CONVERT( DATETIME, '##Date##', 106 )
SELECT a.UserId  AS [User Link],
       COUNT(*) as [Count]
FROM   PostHistory a
WHERE  a.PostHistoryTypeId IN ( 4, 5, 6 )
       AND Upper(a.Comment) LIKE Upper('%##CommentText##%')
       and a.CreationDate > @p_date
GROUP BY a.UserId
ORDER BY [Count] desc

Enter Parameters

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