2

Please login or register to vote for this query.

(click on this box to dismiss)

People keep closing old questions I answered that obviously I think are good questions, or at least salvageable. Since I get no notification of such closing, I created this query.

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT TOP 50
  question.ClosedDate,
  answer.Id as [Post Link]
FROM 
  Posts answer 
JOIN 
  Posts question
ON
  answer.ParentId = question.Id
WHERE 
  answer.PostTypeId = 2 
AND
  answer.OwnerUserId = ##UserId##
AND
  question.ClosedDate IS NOT NULL
ORDER BY
  question.ClosedDate
DESC

view current version

edited sep 9 13

created sep 9 13 Karl Bielefeldt