If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
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
|What is format f12.8 for a CSV file||6||41|
|Access 2010 Query Syntax||5||23|
|t-sql split string into multiple rows||7||37|
|Is it possible to replace huge Multiple Spaces with a single space in SQL Server||2||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!