Monthno m1 m2 m3 1 1 0 0 1 0 1 0 1 0 0 1 2 1 0 0 2 0 1 0
Monthno m1 m2 m3 1 1 1 1 2 1 1 0
SELECT MonthNo, SUM(M1) AS M1, SUM(M2) AS M2, SUM M3 AS M3 FROM MyTable GROUP BY MonthNo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)