Trigger para actualizar inventario

http://4.bp.blogspot.com/-ZxVZlA-0pIQ/USOZtZxFEoI/AAAAAAAAAL8/UK8H0wFL80M/s1600/Sin+t%C3%ADtulo1.png
http://1.bp.blogspot.com/-rUVGlBepsrI/USOZwwH87rI/AAAAAAAAAME/AGRBtTj73lU/s1600/Sin+t%C3%ADtulo2.png

Link de Apoyo : http://www.youtube.com/watch?v=2FiUK8NWuXs

Ejemplo propio para actualizar campo buscando valor en otra tabla:

USE [Lote]
GO
/****** Object:  Trigger [dbo].[PonLineaDesvio]    Script Date: 22/04/21 0:36:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:          Name
-- Create date:
-- Description:    
-- =============================================
ALTER TRIGGER [dbo].[PonLineaDesvio]
   ON  [dbo].[Lote]
   AFTER INSERT,UPDATE
AS
BEGIN
       -- SET NOCOUNT ON added to prevent extra result sets from
       -- interfering with SELECT statements.
       SET NOCOUNT ON;
Update Lote set LineaDesvio=
(SELECT TP.Linea FROM Maestros.dbo.TiposArreglos As TP WHERE Lote.Incidencia = TP.Cod)
From Lote, Inserted
Where Lote.Id=Inserted.Id

    -- Insert statements for trigger here
END

Fuente: https://soportesql.wordpress.com/2013/02/21/clasico-trigger-para-actualizar-inventario/