The most recent content from our members.
--SELECT from Inline View SELECT AVG(a.AVERAGE_of_Availability) as "Total Average", MIN(a.AVERAGE_of_Availability) as "Minimum Average" FROM (SELECT TOP 10000 CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101) AS SummaryMonth, AVG(ResponseTime.Availability) AS AVERAGE_of_Availability FROM Nodes…
It looks like you're new here. Sign in or register to get started.