-- Объявление переменных
DECLARE @PROIZVODSTVO nvarchar(25)= 'Цех сварки'
DECLARE @OBORUD nvarchar(25)= 'Сварочный робот №1'
DECLARE @PARAMETR nvarchar(25)= 'Плотность тока'
DECLARE @PART nvarchar(25)= 'PART10'
	/* Проверка партии на существование*/
IF NOT EXISTS (
	SELECT * 
		FROM Batch, Equipment, Factory  
		WHERE BatchName=@PART 
			AND EquipmentName=@OBORUD
			AND FactoryName=@PROIZVODSTVO
			)
BEGIN
	/*Добавление новой партии*/
INSERT INTO Batch (EquipmentId, BatchName) 
	SELECT EquipmentId,@PART 
			FROM Equipment, Factory
			WHERE EquipmentName=@OBORUD 
				AND Factory.FactoryName=@PROIZVODSTVO 
				AND Equipment.FactoryId = Factory.FactoryId
	/*Добавление предыдущего значения*/
INSERT INTO [Values] (BatchId, ParameterId, [Value]) 
	VALUES(
		(SELECT TOP 1 BatchId
			FROM Parameter, Batch, Equipment, Factory
			WHERE BatchName=@PART AND EquipmentName=@OBORUD 
				AND FactoryName=@PROIZVODSTVO AND ParameterName=@PARAMETR
				AND Batch.EquipmentId=Equipment.EquipmentId), 
		(SELECT Parameter.ParameterId 
			FROM Parameter, Batch, Equipment, Factory, [Values]
			WHERE BatchName=@PART AND EquipmentName=@OBORUD 
				AND FactoryName=@PROIZVODSTVO
				AND Parameter.EquipmentId=Equipment.EquipmentId
				AND Batch.BatchId=[Values].BatchId),
		(SELECT TOP 1 [Value]
			FROM [Values], Batch, Parameter, Equipment, Factory
			WHERE ParameterName=@PARAMETR AND EquipmentName=@OBORUD 
				AND FactoryName=@PROIZVODSTVO AND [Values].ParameterId=Parameter.ParameterId
				AND [Values].BatchId=Batch.BatchId
			ORDER BY [Values].[RecordTime] DESC))
END
ELSE -- Сообщение о существовании партии
BEGIN 
SELECT 'Партия уже существует' 
END