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 top (100)
  q.Id as PostId, 
  q.PostTypeId,
  q.CreationDate as Created, 
  q.Score as Score, 
  q.Body as Description, 
  q.CommentCount as Comments,
  CASE 
    WHEN q.Body LIKE '%/questions/tagged/bug%' THEN 'bug' 
    WHEN q.Body LIKE '%/questions/tagged/support%' THEN 'support' 
    WHEN q.Body LIKE '%/questions/tagged/discussion%' THEN 'discussion' 
    WHEN q.Body LIKE '%/questions/tagged/feature-request%' THEN 'feature-request' 
    ELSE 'no tag'
  END as Tag,
  CASE 
    WHEN q.Body LIKE '%/questions/tagged/status-completed%' THEN 'status-completed' 
    WHEN q.Body LIKE '%/questions/tagged/status-declined%' THEN 'status-declined' 
    WHEN q.Body LIKE '%/questions/tagged/status-review%' THEN 'status-review' 
    WHEN q.Body LIKE '%/questions/tagged/status-bydesign%' THEN 'status-bydesign' 
    ELSE 'no status'
  END as Status
FROM Posts q
ORDER BY q.CreationDate

fork query

edited mar 25

created mar 25 PeterJames