0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @dumpdate datetime
select @dumpdate = max(creationdate) from posthistory

select
  id [Comment Link],
  *
from
  comments
where
  len(text) < 80 and
  text like 'what have you tried%' collate Latin1_General_CI_AS and
  datediff(day, creationdate, @dumpdate) <= 28
order by 
  creationdate desc

fork query

edited may 27 17

created may 27 17 Jason C