Создание DELETE триггера на View

Всех приветствую. Пытаюсь сделать триггер на представлении (View), но возникает ошибка.

Мой триггер:

ALTER TRIGGER [dbo].[PersonClients_DELETE_TRIGGER]
    ON [dbo].[Clients_View]
   INSTEAD OF DELETE 
AS 
BEGIN
    DELETE FROM PersonSet_Client WHERE Id = (SELECT ID FROM PersonSet 
    WHERE FirstName = (select FirstName from deleted) AND
    LastName = (select LastName from deleted))
END

Но возникает проблема:

При удалении данных возникает ошибка:

No rows were deleted. A problem occurred attempting to delete row 9. Error Source: Microsoft. SqlServer. Management. DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows). Correct the errors and attempt to delete the row again or press ESC to cancel the change(s). s)

Что с этим можно сделать?


Ответы (0 шт):