Comments by Hernán Hegykozi (Top 3 by date)

Reason for my vote of 5 \n excellent article!

I leave some more code.

Sum Total:


SELECT SUM(td2.ColValues)
FROM TestData td
UNPIVOT (ColValues FOR ColHeader IN (Col2, Col3)) AS td2


Sum total column:

SELECT td2.ColHeader, SUM(td2.ColValues)
FROM TestData td
UNPIVOT (ColValues FOR ColHeader IN (Col1, Col2, Col3)) AS td2
GROUP BY td2.ColHeader

Reason for my vote of 5
Nice article!! :)