Comments like "What have you tried" where an accepted answer is present

2

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
    c.Id AS [Comment Link],
    c.Score,
    c.CreationDate,
    LEN(Text)
FROM
    Comments c
      INNER JOIN Posts p
      ON c.PostId = p.Id
WHERE Text LIKE 'What have you tried%'
AND p.AcceptedAnswerId IS NOT NULL
AND LEN(Text) < 33
AND p.CommentCount < ##CommentThread:int?4##
ORDER BY
  LEN(Text), c.Score DESC, c.CreationDate

Enter Parameters

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