while 1update #tmp7set fye=fqcye+fdebit-fcredit
declare @i intdeclare @j intdeclare @m int declare @n intset @i=0set @j=0update @tmp7 set fqcye=@i,fye=@i+@j,@i=@i+@j,@j=fqcye+fdebit-fcredit 只是第一条记录的fqcye 变成了0,因为没有上一条记录的fye