mssql 交叉表查询，行向列的转换

如图，根据type值不同，分别求出每天的amount，

select Convert(varchar(10),Date,120) Date,
ROUND(isnull(sum(case when Type=100 then Amount else 0 end),0.0),2,1) aa，
ROUND(isnull(sum(case when Type=54 then Amount else 0 end),0.0),2,1) bb，
ROUND(isnull(sum(case when Type=270 then Amount else 0 end),0.0),2,1) cc，
ROUND(isnull(sum(case when Type=-1 then Amount else 0 end),0.0),2,1) dd

from Income_Detail
where  Date>=‘2012-11-26’ and Date<‘2012-11-29’
group by Date
order by Date