Is there a way that I can get the sum of a column in my query result set by just clicking on the column (something like in Excel) so that I don't have to copy and paste the column into Excel to the see the total sum of all the values in the column?
I'm running SQL Server 2008.
Best Answer
Use the OVER clause to modify a SUM scope in your query. No GROUP BY needed
Otherwise, SSMS isn't a calculating engine: it display query results so add it to your query...