declare @dumpdate datetime select @dumpdate = max(creatio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results