Recent 'P.SE' comments

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

select top ##RowsBack:int?100##
  C.Id as [Comment Link],
  C.Score,
  C.Text,
  C.CreationDate,
  U.DisplayName,
  U.Reputation
from
  comments C
  join users U on (C.userId = U.Id)
where
  C.CreationDate >= CONVERT (datetime, ##StartDate:string?2013.07.01## , 102)
  and C.CreationDate <= CONVERT (datetime, ##EndDate:string?2013.07.31## , 102)
  and ([text] like ##Text:string?%programmers.%##)
order by CreationDate desc

Enter Parameters

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