1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for network engineers

select child.id as [Post Link] from posts as child 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 = child.parentId and child.ownerUserId=##UserId##;

view current version

edited jul 25 12

created jul 25 12 Mark Peters