1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for network engineers

select parent.id as [Post Link] from comments join (select p.id from posts p inner join users u 
on (p.ownerUserId=u.id) 
and (DATEDIFF(d, u.CreationDate, p.CreationDate) < 3)
where p.postTypeId = 1) parent 
ON parent.id = comments.postId 
and comments.userId=##UserId##;

view current version

edited jul 25 12

created jul 25 12 Mark Peters