0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

WITH
QUESTIONS AS(
  SELECT Id,Body FROM Posts 
  WHERE PostTypeId=1 AND AnswerCount >= 10  AND CONVERT(VARCHAR(250), Tags) = '<c>'
  ),
ANSWERs AS(
  SELECT q.Body as Query,a.Body as Reply from Posts as a, QUESTIONS as q 
  WHERE a.PostTypeId=2 AND a.ParentID=q.Id
  ),
TOTAL AS(
  SELECT a.* FROM QUESTIONS AS q,ANSWERS as a
  )
SELECT * FROM TOTAL

fork query

edited may 25

created may 25 jon.doe44415