Код

	|declare @spis numeric (12,3)
	|declare @p_row_id int, @p_id int, @p_kol numeric (12,3), @p_kolf numeric (12,3)
	|declare cur cursor for select row_id, id, kol, kolf from Tkontrol where iddoc = :ÒåêÇàÿâêà order by row_id
	|open cur
	|fetch next from cur into @p_row_id, @p_id, @p_kol, @p_kolf
	|while (@@fetch_status <> -1)
	|begin
	|set @spis = @p_kolf - isnull((select sum(kolost) from Tkontrol where id = @p_id and row_id < @p_row_id), 0)
	|set @spis = case when @p_kol < @spis then @p_kol else @spis end
	|update Tkontrol
	|set kolost =  @spis
	|where row_id = @p_row_id
	|fetch next from cur into @p_row_id, @p_id, @p_kol, @p_kolf
	|end
	|close cur
	|deallocate cur