SELECT id,Name FROM TeachSite GROUP BY idselect top 1000  1 as [type],SchoolRollID,ChargeableAmount  into #temp from ChargeRecord where bflag=1select * from #temp  select 2 as [type], SchoolRollID,SUM(ChargeableAmount) as xjinto #tempxj from #temp   group by SchoolRollID select 0 as  [typq], null as  SchoolRollID ,SUM(xj) as hj  into #temphj from #tempxj  select *  from #tempinsert  into #temp select * from #tempxjinsert  into #temp select * from #temphj select * from #temp order by SchoolRollID,[type] desc