如图,根据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