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.