递归累计求和

实现 

if not object_id('tempdb..#tmp_data') is null 
      drop table #tmp_data
create table #tmp_data(
                 List_ID int identity(1,1),
TradeActAmt decimal(13,2),
MerchantNo varchar(20))
insert into #tmp_data
Select 0.01,'A' UNION 
Select 0.01,'B' UNION
Select 0.01,'C' UNION
Select 8, 'D'


select * From #tmp_Data

Select *,(Select sum(TradeActAmt) From #tmp_Data b Where b.List_ID<=a.List_ID) as '逐行累加'
From #tmp_Data a