0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

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

created oct 3 23 anonymous