CREATE TRIGGER tr_delete_Products ON [dbo].[Products] 
FOR DELETE 
AS
DECLARE @date datetime
BEGIN

IF @@ROWCOUNT = 0
	RETURN

SET @date = GETDATE()

UPDATE IDL
SET DeleteUser = USER, DeleteTime = GETDATE()
FROM Deleted As D INNER JOIN NorthwindLog.dbo.Products_InsertedDeletedLog AS IDL
ON D.UniqueID = IDL.UniqueID

END
GO