0

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 
  q.Id AS QuestionId,
  q.Title AS QuestionTitle,
  q.tags AS Tags,
  q.Body AS QuestionBody,
  a.Id AS AnswerId,
  a.Body AS AnswerBody
  
FROM
  Posts q
  INNER JOIN Posts a ON q.AcceptedAnswerId = a.Id
WHERE
  q.CreationDate >= DATEADD(month, -1, GETDATE())
  AND q.CreationDate < GETDATE()
  AND q.PostTypeId = 1
  AND a.PostTypeId = 2
  AND q.tags like '%<##tag?powershell##>%'

fork query

edited oct 3 23 anonymous

created mar 14 15 nhgrif