0

Please login or register to vote for this query.

(click on this box to dismiss)

Your answers sorted by the time after question creation they were posted, excluding answers that were later merged with a question newer than the answer.

Q&A about the site for enthusiasts and scholars of mythology and folklore

-- Which answers did I submit most quickly?
-- Your answers sorted by the time after question creation they were posted,
-- excluding answers that were later merged with a question newer than the answer.

select top 500
    a.Id as [Post Link],
    cast(floor(cast(a.CreationDate - q.CreationDate as float)) as varchar) + ':' +
        convert(varchar, a.CreationDate - q.CreationDate, 8)
        as [Time to Answer]
from Posts as a
    inner join Posts as q on q.Id = a.ParentId
where
    q.PostTypeId = 1 and
    a.PostTypeId = 2 and
    a.OwnerUserId = ##UserId## and
    a.CreationDate > q.CreationDate
order by a.CreationDate - q.CreationDate

fork query

created may 25 11 PleaseStand