Hi

Have a look at ROLLUP, I think this will do what you want.

SELECTComputerName AS 'Computer Name',

SUM(BlackWhiteTotalCount) AS 'Total B&W Pages',

SUM(FullColorTotalCount) AS 'Total Color Pages',

Name AS 'Printer Name'

FROM [dbo].[db_name]

WHERE ComputerName LIKE 'ComputerName%' --There are 2 computer names that I'm looking at

GROUP BY ROLLUP (ComputerName, Name)