0

Please login or register to vote for this query.

(click on this box to dismiss)

Open questions with answers, at least one answer having score 0, no answer having score > 0 (a.k.a. zombies ready for killing)

Q&A for project managers

DECLARE @username AS NVARCHAR(60) = ##DisplayName:string? ##;
DECLARE @userId AS INT = ##UserId:int?-1##;

SELECT TOP ##Limit:int?100##
  u.Id AS [User Link],
  q.Id AS [Post Link],
  q.CreationDate,
  u2.Id AS [User Link],
  a.CreationDate
FROM Posts q
  JOIN Users u ON q.OwnerUserId = u.Id
  JOIN Posts a ON a.ParentId = q.Id
  JOIN Users u2 ON a.OwnerUserId = u2.Id
WHERE 
  (@username = '' OR u.DisplayName = @username)
  AND (@userId = -1 OR u.Id = @userId)
  AND q.AcceptedAnswerId IS NULL
  AND q.ClosedDate IS NULL
GROUP BY q.Id, u.Id, q.CreationDate, u2.Id, a.CreationDate
HAVING MAX(a.Score) = 0
ORDER BY q.CreationDate

fork query

edited mar 25 anonymous

created dec 18 15 Janos