1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT 
  Id As [Post Link], 
  CreationDate, Score, AnswerCount, ViewCount, Tags, Title,
  CASE PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
    WHEN 3 THEN 'Orphaned tag wiki'
    WHEN 4 THEN 'Tag wiki excerpt'
    WHEN 5 THEN 'Tag wiki'
    WHEN 6 THEN 'Moderator nomination'
    WHEN 7 THEN 'Wiki placeholder'
    WHEN 8 THEN 'Privilege wiki'    
  END
FROM Posts
WHERE (OwnerDisplayName='user' + Convert(nvarchar(20), ##UserId?9072##))
AND (PostTypeId IN (##types?1,2##))
---1=questions
---2=answer
---1,2=both
ORDER BY CreationDate DESC

fork query

created sep 1 23 Martin20528