0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns table of user's answers, along with post ID, date answered, question score, date asked, and question views. Output CSV file is designed to be used together with https://github.com/c-white/stackexchange_analysis

Q&A for active researchers, academics and students of physics

DECLARE @UserId int = ##UserId##

SELECT
  A.Id as [Id],
  A.Score as [Answer Score],
  A.CreationDate as [Answer Date],
  Q.Score as [Question Score],
  Q.CreationDate as [Question Date],
  Q.ViewCount as [Views]
FROM
  Posts A INNER JOIN
  Posts Q on Q.Id = A.ParentId
WHERE
  A.OwnerUserId = @UserId AND
  A.PostTypeId = 2 --answers
ORDER BY
  [Answer Score] DESC

fork query

edited feb 21 15

created feb 15 15 Chris White