Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Join the community of 500,000 technology professionals and ask your questions.