0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created jul 10 12 Ashwin kumar