Questions that are self answered


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 top 1000 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 = q.AcceptedAnswerId
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and a.owneruserid = q.owneruserid
and a.owneruserid = 895245

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results