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
|SQL Select * from||6||43|
|Table create permissions on SQL Server 2005||9||43|
|Getting max record but maybe not use Group BY||2||32|
|SSIS I need to get the most old file from a folder in the SSIS package.||3||39|