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 Account, count(*) as ct FROM Table1 where version like 'x.0.0' and Account != '' and DATEDIFF(day, ReceivedDate,GETDATE()) < 30 group by Account having count(*) >= 5 order by ct desc; select Account, count(*) as ct_dev from Table1 t1 left outer join Table2 t2 on t1.tr = t2.DevTr where DevTr is not null and account is not null and account <> '' and DATEDIFF(day, ReceivedDate,GETDATE()) < 30 group by Account order by ct_dev desc;
|How to write a sql query returning a result with my date time template?||8||33|
|Why don't I see Below columns in my Stored Procedure under TMP_RS?||8||19|
|MULTIPLE DATE QUERY||15||53|
|Trouble analysing a database||9||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!