实现
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