Select *, Datediff(Day,B.Creationdate,(Select Min(Creatio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Server Fault

Q&A for system administrators and IT professionals

Select *, Datediff(Day,B.Creationdate,(Select Min(Creationdate) From Posts  Where Parentid = B.Id) ) 
From Posts B
Where B.Posttypeid = 1 and month(creationdate) = 12  and year(creationdate) = 2016
And B.Answercount > 0 
  And Datediff(Day,B.Creationdate,(Select Min(Creationdate) From Posts  Where Parentid = B.Id) ) >= 30

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results