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 for professional and enthusiast programmers

-- 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

SET nocount on

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

SELECT
    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
    AND p.OwnerUserId = ##UserId##
ORDER BY
    p.CreationDate DESC

fork query

edited jul 10 12 Ashwin kumar

created mar 9 11 tj