逐筆向前回寫的SQL

SQL：

drop table #tmp

select '20120301' datadate
	, '020' brno
	, null amt
	, 1 rid
into #tmp	 

insert into #tmp
select '20120302','020',null ,2
union all
select '20120303','020','333' ,3
union all
select '20120304','020',null , 4
union all
select '20120305','020','555' ,5
union all
select '20120306','020','666' ,6

select * from #tmp order by rid
--select * into #tmp_1 from #tmp
select * from #tmp_1 order by rid

update A set A.amt= B.amt
from #tmp A
left join #tmp B
on 1=1
where  b.rid > A.rid and B.brno = A.brno
and B.amt is not null and A.amt is null

結果：