select b.projno, b.projname, 'Overlaps ' + a.projno + ' ' + a.projname as 'Overlaps'
from projects a, projects b
where a.projno != b.projno and
      b.prstdate >= a.prstdate and
      b.prstdate <= a.prendate
order by b.projno;
go