Find unaccepted own answers to question

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select q.id as [Post Link],
'http://stackoverflow.com/a/' + CAST(a.id as nvarchar) as [Answer Link]
FROM posts q 
       INNER JOIN posts a 
               ON a.parentid = q.id 
                  AND a.owneruserid = q.owneruserid
                  AND a.id <> q.AcceptedAnswerId
where a.OwnerUserId = ##UserId##

Enter Parameters

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