Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
select a.lastname,a.firstname,a.middlename, effdate,entercode,leavecode, DATEDIFF(day,effdate, (Select MIN(effdate) from Table1 b where b.lastname=a.lastname and b.firstname=a.firstname and b.effdate > a.effdate)) NoDays from Table1 a order by a.lastname,a.firstname,a.middlename
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.