Luis Cazares (7/24/2013)

---

I believe this option is better for performance.

SELECT ID,

SUM( CASE WHEN Type = 'a' THEN Amount ELSE 0 END) AS Amount_A,

...

Thank you for your quick answer, which definitely made me feel welcome. And even better, appears to work.

On a sidenote: maybe for your next...