score:3

Accepted answer
select
     p.*
from
     dbo.gettablefromidlist(@id_list) u
inner join workplans wp1 on
     wp1.userid = u.id
left outer join dbo.workplans wp2 on
     wp2.userid = wp1.userid and
     wp2.date > wp1.date
inner join dbo.projects p on
     p.workplanid = wp1.workplanid
where
     wp2.workplanid is null

Related Query