Lists all questions I have proposed an answer to, but the original question asker hasn't accepted an answer
Q&A for SharePoint enthusiasts
-- Questions I have answered where asker has not accepted an answer -- Lists all questions I have proposed an answer to, but the original question asker hasn't accepted an answer SELECT p.Id AS [Post Link], p.AnswerCount FROM Posts a, Posts p WHERE a.OwnerUserId = ##UserId## AND a.PostTypeId = 2 AND p.AcceptedAnswerId IS NULL AND p.Id = a.ParentId ORDER BY p.AnswerCount DESC