0

Please login or register to vote for this query.

(click on this box to dismiss)

Show the N most recent answers tagged X from user Y. See also http://data.stackexchange.com/stackoverflow/s/1071 [Note: The site's own search facility can do most of this, and probably better; details: http://stackoverflow.com/search]

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

-- N most recent answers tagged X from user Y
-- Show the N most recent answers tagged X from user Y. See also http://data.stackexchange.com/stackoverflow/s/1071

declare @tagid int

SELECT @tagid = Id FROM Tags WHERE TagName = ##JustOneTag:string##

SELECT TOP ##Limit##
    p.Tags as [T],
    p.Id as [Post Link],
    p.CreationDate as [Answer Date]
FROM
    Posts p
INNER JOIN
    PostTags pt ON p.ParentId = pt.PostId AND pt.TagId = @tagid
WHERE
    p.PostTypeId = 2 -- 2 = Answer
ORDER BY
    p.CreationDate DESC

fork query

edited jun 13 19 anonymous

created mar 9 11 tj