Get questions you've answered with your answers

2

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 
  q.Score as [QScore],
  q.Id as [Post Link],
  q.Title,
  q.Tags,
  q.Body as [Question Body],
  q.OwnerUserId as [Questioner],
  a.Score as [AScore],
  a.Body as [Answer Body],
  a.CreationDate as [AnswerDate]
FROM
  Posts as q
    Join Posts as a
      on a.ParentId = q.Id
WHERE
  a.OwnerUserId=##UserId##
  --q.Id in (SELECT ParentId FROM Posts 
    --WHERE OwnerUserId=##UserId## and PostTypeId=2)

Enter Parameters

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