1

Please login or register to vote for this query.

(click on this box to dismiss)

Hijack recent insightful to generate my own comments.

Q&A for Drupal developers and administrators

-- My recent comments
-- Same as top 500 comments but ordered by date

DECLARE @UserId int = ##UserId##

select top 500
  PostId as [Post Link],
  CreationDate,
  [Text],
  Score
  from Comments c  
where UserId = @UserId
order by c.CreationDate desc

fork query

created nov 26 10 pinegreendragon