1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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)

fork query

edited jun 13

created jun 13 Martin20528