Frage an die SQL-Spezies :-)

[Fuerchau]

Das ist zugegeben etwas mühsam:

Select Key, sum(spalte1) as spalte1, sum(0) as spalte2, sum(0) as spalte3, ... from myfile
where ...
Group by Key
union
select Key, sum(0) as spalte 1, sum(splate2) as spalte2, sum(0) as spalte3, ... from myfile
where ...
Group by Key
union
select Key, sum(0) as spalte1, sum(0) as spalte2, sum(spalte3) as spalte3, ... from myfile
where ...
Group by Key

Order by Key

Dieses Muster kannst du ja nun auf deine 2*12-Monatsspalten erweitern.
Viel Spaß beim tippen