Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
USE [db1] DECLARE @endDate datetime DECLARE @startDate datetime SET @startDate = '2011-08-01 00:00:00.000' SET @endDate = '2011-09-30 23:59:59.997' select convert(char(10), SetupTime,104) as 'DATE' , '24 hr' AS 'PERIOD' , cast( Cast(isnull(SUM(ChargeableAmount), 0) AS DECIMAL(18,2)) / 100000 AS DECIMAL(18,2)) AS 'TOTAL' , cast( Cast(isnull(SUM(case LocationZoneID when 167 then ChargeableAmount end), 0) AS DECIMAL(18,2)) / 100000 AS DECIMAL(18,2)) AS 'CFW' from [CDRData] WHERE (Direction = 1) AND (COSID =95) AND (SetupTime BETWEEN @startDate AND @endDate) group by convert(char(10), SetupTime,104) order by 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Hardware Resources for a Microsoft database only workstation versus .NET development only..||6||96|
|SQL Query Across Multiple Tables - Help||5||48|
|Need a mirrored QA test site||2||93|
|2008 to 2016 jump (SQL Server)||1||32|
Join the community of 500,000 technology professionals and ask your questions.