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
  p2.Id as [Post Link]
FROM 
  Posts p 
JOIN 
  Posts p2
ON
  p.ParentId = p2.Id
WHERE 
  p.PostTypeId = 2 
AND
  p.OwnerUserId = ##UserId##
AND
  p2.ClosedDate IS NOT NULL
ORDER BY
  p2.ClosedDate
DESC

view current version

edited sep 9 13

created sep 9 13 Karl Bielefeldt