Не работает перенос записей, если их несколько

CREATE PROCEDURE Use_term
AS
DECLARE @ID INT, @Name VARCHAR(MAX), @Number INT, @Information VARCHAR(MAX)
SET @ID = (SELECT Equipment_list.ID_equipment FROM Equipment_list, Installation_site WHERE Equipment_list.ID_equipment = Installation_site.ID_equipment AND SYSDATETIME() >= Installation_site.Operation_term)
SET @Name = (SELECT Equipment_list.Name FROM Equipment_list, Installation_site WHERE Equipment_list.ID_equipment = Installation_site.ID_equipment AND SYSDATETIME() >= Installation_site.Operation_term)
SET @Number = (SELECT Equipment_list.Accession_number FROM Equipment_list, Installation_site WHERE Equipment_list.ID_equipment = Installation_site.ID_equipment AND SYSDATETIME() >= Installation_site.Operation_term)
SET @Information = (SELECT Equipment_list.Additional_information FROM Equipment_list, Installation_site WHERE Equipment_list.ID_equipment = Installation_site.ID_equipment AND SYSDATETIME() >= Installation_site.Operation_term)
IF @ID IS NOT NULL
INSERT INTO List_of_the_written_off VALUES(@Name, @Number, @Information, 'Срок использования истек')
DELETE FROM Installation_site WHERE(@ID = Installation_site.ID_equipment)
DELETE FROM Equipment_list WHERE(@ID = Equipment_list.ID_equipment)

CREATE PROCEDURE Use_term
AS
BEGIN
    INSERT
        INTO List_of_the_written_off
        SELECT Equipment_list.Name, Equipment_list.Accession_number, Equipment_list.Additional_information, 'Срок использования истек'
            FROM Equipment_list
                INNER JOIN Installation_site
                    ON Equipment_list.ID_equipment = Installation_site.ID_equipment
            WHERE SYSDATETIME() >= Installation_site.Operation_term
    DELETE
        FROM Installation_site
        WHERE SYSDATETIME() >= Installation_site.Operation_term
    DELETE
        FROM Equipment_list
        WHERE SYSDATETIME() >= Installation_site.Operation_term
END

INNER JOIN Installation_site
ON Equipment_list.ID_equipment = Installation_site.ID_equipment

-- Именно в таком порядке
DELETE
        FROM Equipment_list
        WHERE Id_Equipment IN (SELECT Id_Equipment
                                                FROM Installation_site
                                                WHERE SYSDATETIME() >= Operation_term)
DELETE
        FROM Installation_site
        WHERE SYSDATETIME() >= Operation_term