Home Forums SQL Server 2008 T-SQL (SS2K8) SQL query to sum data RE: SQL query to sum data
jamie_collins
Ten Centuries
Points: 1192
More actions
December 7, 2013 at 7:44 pm
#1671743
Got it:
with cte as
(
SELECT Database, MONTH(Date) AS Month, max(Size) AS Size
FROM DatabaseSize_Archive
WHERE Server = 'CS1'
GROUP BY MONTH(Date)
)
SELECT Month, SUM(Size)
FROM cte
GROUP BY Month
ORDER BY Month DESC