2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

-- UserId: User ID
DECLARE @UserId int = ##UserId:int##;

SELECT
  answers.Id as [Post Link]
FROM
  Posts as answers
INNER JOIN Posts as questions ON
  answers.ParentId = questions.Id
WHERE
  answers.OwnerUserId = @UserId AND
  questions.ClosedDate IS NOT NULL
ORDER BY
  answers.CreationDate DESC

fork query

created jul 8 20 jon.doe33355