2

Please login or register to vote for this query.

(click on this box to dismiss)

Search your own comments for a string. Results show the comment, its score, the date, and a link to the post, newest comments first.

Q&A for amateur radio enthusiasts

DECLARE @MyUserID INT = ##UserID:int##

SELECT
    Comments.Id AS [Comment Link],
    Comments.CreationDate,
    Comments.PostId AS [Post Link]
FROM Comments, Posts Answer
LEFT JOIN Posts Question ON Answer.ParentId = Question.id
WHERE
    Comments.PostId in (Answer.Id, Question.Id) AND
    Answer.Id = Question.AcceptedAnswerId  AND
    Answer.PostTypeId = 2 AND
    Answer.OwnerUserId = @MyUserID AND
    Comments.UserId = ##UserID## AND
    Comments.Text LIKE '%/questions/5234/how-does-accepting-an-answer-work%'
ORDER BY Comments.CreationDate DESC

fork query

edited aug 3 14 Martijn Pieters

created aug 11 12 Brad Mace