User's unanswered questions...

2

Please login or register to vote for this query.

(click on this box to dismiss)

This query returns the linked list of the unanswered questions of a certain user. The OtherUserID parameter is the ID of a user whose unanswered questions you want to list.

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @OtherUserID INT = ##OtherUserID:int##

SELECT
    Id AS [Post Link],
    Score AS [Score],
    AnswerCount AS [Answer Count],
    CreationDate AS [Creation Date]
FROM
    Posts
WHERE
    OwnerUserId = @OtherUserID AND
    PostTypeId = 1 AND
    AcceptedAnswerId IS NULL
ORDER BY
    CreationDate
ASC

Enter Parameters

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