0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

Select Distinct 
  a.Id, 
  a.CreationDate, 
  t.TagName,
  Case p.AcceptedAnswerId-a.Id 
    When 0 Then 'Accepted' 
    Else '' 
    End as Accepted,
   p.Title, p.Tags, 
   CONCAT('http://stackoverflow.com/questions/', p.Id, '#answer-', a.Id) as Link
   --,vu.DisplayName
From Posts a 
   Inner Join Posts p On a.ParentId = p.Id 
   Inner Join PostTags pt on p.Id = Pt.PostId
   Inner Join Tags t on pt.TagId = t.Id
WHERE a.CreationDate > Convert(datetime, '2021-01-01' )
  AND p.PostTypeId = 1
  And (t.TagName LIKE 'open-telemetry%')
  --And a.CreationDate >= DATEADD(Day, -14, Getdate())  -- Last two weeks answers 
Order by a.CreationDate desc

fork query

edited jan 25 anonymous

created aug 30 henrisycip