My answers to questions that have no accepted answer

2

Please login or register to vote for this query.

(click on this box to dismiss)

See http://meta.stackoverflow.com/questions/178806/search-for-not-accepted-questions-within-my-answers

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @UserId         INT     = ##UserId##;

SELECT      A.score,
            A.id AS [Post Link],
            Q.LastActivityDate
FROM        posts               A
INNER JOIN  posts               Q
ON          Q.id                = A.parentid
AND         Q.AcceptedAnswerId  IS NULL
WHERE       A.posttypeid        = 2             -- Answers
AND         A.owneruserid       = @UserId       -- By the specified user
ORDER BY    A.score             DESC,
            Q.LastActivityDate  DESC,
            Q.Title             ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results