Self-answers from SO user 22448

Please login or register to vote for this query.

(click on this box to dismiss)

Self-answers from SO user 22448; see http://meta.stackoverflow.com/questions/118042/a-way-to-reduce-criticism-and-down-voting-for-answering-your-own-question

Q&A for programmers

-- Self-answers from SO user 22448
-- Self-answers from SO user 22448; see http://meta.stackoverflow.com/questions/118042/a-way-to-reduce-criticism-and-down-voting-for-answering-your-own-question

select q.Id as [Post Link],
  q.CreationDate as [Question],
  a.CreationDate as [Answer]
from posts as q
join posts as a
  on a.OwnerUserId = q.OwnerUserId
  and a.ParentId = q.Id
where q.OwnerUserId = 22448

created jan 7 12