Most Interesting Recent Comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Database Administrators

Q&A for database professionals who wish to improve their database skills and learn from others in the community

SELECT TOP 100 c.PostId AS [Post Link], c.Score, c.UserId AS [User Link],
c.Id AS [Comment Link]
  FROM dbo.Comments c
  WHERE c.CreationDate >= DATEADD(dd, (-1 * ##DaysBack:int?30##), GETDATE())
    AND c.UserId NOT IN
      (SELECT TRY_CAST(value AS BIGINT) FROM STRING_SPLIT(##IgnoredUserIds:string?-1,26837,2639##, ','))
  ORDER BY c.Score DESC;

Enter Parameters

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