declareavgs cursor scroll for selectsale from table
declare@saleint,@coun int,@sale1int
set @conu=1
open avgs
fetch first from avgs into @sale
set@sale1=@sale
while @@fetch_status=0
begin
updatetable
set avgsalse=@sale1/@coun
where sale=@sale
fetch next from avgs into @sale
set @sale1=@sale1+@sale
set @coun=@coun+1
end
close avgs
deallocate avgs
前提是sale 不重复