0

Please login or register to vote for this query.

(click on this box to dismiss)

Any edit summary comment from random♦ that's over 100 characters is sure to be an interesting read.

Q&A for community managers, administrators, and moderators

SELECT TOP 50 
  ROW_NUMBER() OVER(partition by a.Comment   order by newid()), 
  a.Comment AS [Ridiculous Comment]
FROM PostHistory a
WHERE
  a.PostHistoryTypeId IN (4,5,6) 
  AND a.UserId = 9314
  AND LEN(a.Comment) > 100
GROUP BY a.Comment
ORDER BY newid()

view current version

edited mar 22 12

created mar 22 12 jadarnel27