Questions that are self answered by own user

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/234635/is-there-a-way-to-search-for-answer-your-own-question-questions

Stack Overflow

Q&A for professional and enthusiast programmers

select top 1000 q.id as [Post Link]
     , q.owneruserid as [User Linkl]
     , q.creationdate as [Asked on]
     , a.creationdate as [Answered On] 
from posts q 
inner join posts a on a.id = q.AcceptedAnswerId
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and a.owneruserid = q.owneruserid
and a.owneruserid = ##UserId?895245##

Enter Parameters

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