Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!