Scores for my answers

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

Physics

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

Enter Parameters

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