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.
DECLARE @begJan DATETIME, @endJan DATETIME, @begJanPrev DATETIME, @endJanPrev DATETIME SET @begJan = '01/01/2016' SET @endJan = '01/31/2016' SET @begJanPrev = '01/01/2015' SET @endJanPrev = '01/31/2015' select B.store_Num as [Store Name], A.store_UIN as [Store Code], B.store_Name as [Store Name], FORMAT(SUM(total-tax), 'C', 'en-us') AS [Sales], COUNT(RO_NO) as [Car Count], FORMAT((((SUM(TAX_PARTS + NTX_PARTS + TAX_LABOR + NTX_LABOR + TAX_SUBLET + NTX_SUBLET - DISP - DISL -DISS)) - (SUM(P_COST + T_COST))) / (SUM(TAX_PARTS + NTX_PARTS + TAX_LABOR + NTX_LABOR + TAX_SUBLET + NTX_SUBLET - DISP - DISL -DISS))), 'P', 'EN-US') as [GPM], FORMAT(((SUM(TAX_PARTS + NTX_PARTS + TAX_LABOR + NTX_LABOR + TAX_SUBLET + NTX_SUBLET + SUPPLIES - DISP - DISL -DISS)) / (COUNT(RO_NO))), 'C', 'EN-US') as [ARO], from HRO as A left JOIN StoreInfo as B ON A.store_UIN = B.store_UIN where ( PAY_DATE >= @begJan) And (PAY_DATE <= @endJan) and Status IN ('C','Q') group by B.store_Num, A.store_UIN, B.store_Name, B.store_OpeningDate, B.store_UIN order by B.store_Num, A.store_UIN asc
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|CASE Statement using different fields||8||35|
|Replace statements HTML with HTML IF||8||69|
|File attachment in the SQL Database from application||10||48|
|Access - convert query for SQL Server||5||19|
Join the community of 500,000 technology professionals and ask your questions.