0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

DECLARE @userid INT
SET @userid = (SELECT Id FROM Users WHERE DisplayName = 'mosvy')
SELECT @userid
SELECT Id AS [Comment Link], CreationDate, Text
  FROM Comments
 WHERE UPPER(Text) LIKE UPPER('%##CommentText##%')
 AND UserId = STR(@userid)
 ORDER BY CreationDate DESC

view current version

edited may 5 19

created may 5 19 mosvy