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.
WITH CTE AS ( SELECT *, ROW_NUMBER() OVER(ORDER BY pid, MDATE ) Serial FROM #table ) SELECT x.*, CASE WHEN y.pid IS NOT NULL THEN 'FLAG' ELSE '' END FLAG FROM CTE x LEFT JOIN ( SELECT a.* FROM CTE a LEFT JOIN CTE b ON a.Serial - 1 = b.Serial AND a.pid = b.pid WHERE b.MHEIGHT > a.MHEIGHT ) y ON x.pid = y.pid AND x.MDATE = y.MDATE
|Excel conversion issue with Sql server||14||46|
|MS SQL - Conversion failed when converting the varchar value||3||22|
|ASP.NET 5 Templates||2||65|
|how can i make refactoring for below code for making faster?||4||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!