Fastest answers

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 TOP 100
  q.OwnerUserId AS [User Link],
  a.Id AS [Post Link],
  DateDiff(s, q.CreationDate, a.CreationDate) AS [Response time],
  Len(ah.Text) AS [Initial length]
FROM Posts q, Posts a, PostHistory ah
WHERE a.ParentId = q.Id
  AND ah.PostId = a.Id AND ah.PostHistoryTypeId = 2
  AND a.OwnerUserId = ##AnswererId##
ORDER BY a.CreationDate - q.CreationDate

Enter Parameters

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