Home Forums SQL Server 2008 SQL Server Newbies Summing SQL SUM's RE: Summing SQL SUM's

  • April 10, 2014 at 1:17 pm

    #1705021

    you could simply sum the two together as a third column, i'd think:

    SELECTComputerName AS 'Computer Name',

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

    SUM(FullColorTotalCount) AS 'Total Color Pages',

    SUM(BlackWhiteTotalCount) + SUM(FullColorTotalCount) AS 'Total of All 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 ComputerName, Name

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!