0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

DECLARE @MyPosts TABLE(Id INT PRIMARY KEY);
INSERT @MyPosts 
VALUES (10259157), (7299871), (3644305), (10671558), 
(7490758), (6504173), (8015482), (7667073), (10588556),
(10603095);

SELECT *
FROM Posts x
INNER JOIN @MyPosts y ON x.Id = y.Id
WHERE x.PostTypeId = 2 --A
--AND x.ParentId = q.Id

view current version

edited may 26 12

created may 26 12 jon.doe7881