Q&A for designers and implementers of computer programming languages
SELECT p.Id As [Post Link], p.CreationDate, p.Score, CASE p.PostTypeId WHEN 1 THEN 'Question' WHEN 2 THEN 'Answer' END, q.Tags, q.ViewCount, q.Title FROM Posts q INNER JOIN Posts p ON coalesce(p.ParentId, p.Id)=q.Id WHERE (p.OwnerDisplayName='user' + Convert(nvarchar(20), ##UserId##)) AND (q.PostTypeId=1)