My answers to questions that have no accepted answer


Please login or register to vote for this query.

(click on this box to dismiss)


Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @UserId         INT     = ##UserId##;

SELECT      A.score,
   AS [Post Link],
FROM        posts               A
INNER JOIN  posts               Q
ON                = 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

Switch sites:
loading Hold tight while we fetch your results