1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- 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
  AND questions.ClosedDate < answers.CreationDate
ORDER BY
  answers.CreationDate DESC

fork query

edited feb 2 blackgreen

created jul 8 20 jon.doe33355