Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Add Total to the query RE: Add Total to the query

  • December 18, 2013 at 5:48 am

    #1674372

    If the solution from Abu Dina is oversimplified, below is a more practical solution.

    SELECT GroupName, SUM(NumberOfCases) as NumberOfCases

    FROM #TempTable

    GROUP BY GroupName

    UNION ALL

    SELECT 'Grand Total' as GroupName, SUM(NumberOfCases)

    FROM #TempTable

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **