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