0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

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

fork query

edited apr 3 12

created apr 3 12 Gilles