How in sqlserver do I go from this:

to this :

Many thanks...

Regards,

CodePudding user response：

SELECT
    SUM ( [January] ) AS [January],
    SUM ( [February] ) AS [February]
FROM MyTable;

This SUMs the value for each column specified. Without more details, there is no telling if additional grouping is needed, but it does sum your column values for a resultset--assuming that is your intent, and not looking for MAX, etc.