Use a CASE expression in your SUM statement, something like this:
...
SUM(CASE WHEN Year = 2010 THEN Amount ELSE 0 END) AS Total2010,
SUM(CASE WHEN Year = 2011 THEN Amount ELSE 0 END) AS Total2011
...
Alternatively, you could use PIVOT. Or you could write a report in Reporting Services to display your data in the way you need.
John