0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

-- Replace '123456' with the actual user ID
DECLARE @UserId INT = 8725045;

-- Replace 'python;javascript' with the desired tags (semicolon-separated)
DECLARE @Tags NVARCHAR(255) = 'python';

SELECT
    a.Id AS AnswerId,
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    a.Body AS AnswerBody,
    a.Score AS AnswerScore,
    a.CreationDate AS AnswerCreationDate
FROM
    Posts q
JOIN
    Posts a ON q.Id = a.ParentId
WHERE
    a.OwnerUserId = @UserId
    AND CHARINDEX(';'+a.Tags+';', ';'+@Tags+';') > 0
ORDER BY
    a.CreationDate DESC;

fork query

edited dec 9

created dec 9 anonymous