ALTER PROCEDURE add_cost_to_nakladnaya
	@id int,
	@cost money
AS
	DECLARE @old_total money, @f float, @d money

SET NOCOUNT ON
BEGIN TRANSACTION

	SELECT @old_total = SUM(pdi.subtotal)
	FROM primary_doc_items pdi
	WHERE pdi.primary_doc = @id
	IF @@ERROR <>  0  GOTO error

	SET @f =  1  + (CONVERT(float,@cost) / CONVERT(float,@old_total))

	UPDATE primary_doc_items SET
		price = CONVERT(money,ROUND(CONVERT(float,price) * @f, 2 ))
	WHERE primary_doc_items.primary_doc = @id
	IF @@ERROR <>  0  GOTO error

	SELECT @d = SUM(pdi.subtotal) - @old_total - @cost
	FROM primary_doc_items pdi
	WHERE pdi.primary_doc = @id

	UPDATE primary_doc_items SET
		price = price - ROUND(@d / quantity, 2 )
	WHERE primary_doc = @id
		AND EXISTS(SELECT TOP  1   1  FROM primary_doc_items pdi WHERE pdi.id = primary_doc_items.id ORDER BY pdi.quantity, pdi.price DESC)
	IF @@ERROR <>  0  GOTO error

COMMIT TRANSACTION
GOTO release
error:
ROLLBACK TRANSACTION
release:
GO