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 top 10
  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 '%powershell%Runspace%WPF%'

view current version

edited oct 3 23

created oct 3 23 anonymous