ALTER TRIGGER [tr_tblRecorrido_Puntos_DELETE]
ON tblRecorrido_Puntos
AFTER DELETE
AS
BEGIN
	DECLARE @idRuta_Guid nvarchar(50)
	DECLARE @idRamal_Guid nvarchar(50)
	DECLARE @idRutaRamal int

	--Variables
	SET @idRutaRamal = (SELECT TOP 1 intId_Ruta_Ramal FROM deleted)
	SELECT TOP 1 @idRuta_Guid = idRuta_Guid, @idRamal_Guid = idRamal_Guid 
	FROM tblRutaRamal_Generado WHERE intId_Ruta_Ramal = @idRutaRamal
	
	--Made this in order to see that my variables weren't empty
	INSERT INTO Prueba(str50_1, str50_2, int_1) VALUES(@idRuta_Guid, @idRamal_Guid, @idRutaRamal)
	
	-- Borrar aquellos elementos que ya no pertencezcan a la colección.
	DELETE tblItinerario FROM tblItinerario
	WHERE idRuta_Guid = @idRuta_Guid AND idRamal_Guid = @idRamal_Guid AND
	intPunto NOT IN (SELECT intPunto FROM tblRecorrido_Puntos WHERE intId_Ruta_Ramal = @idRutaRamal AND (intId_Tipo = 1 OR intId_Tipo = 2 OR intId_Tipo = 3))

END

quote:

---

Originally posted by visakh16

are you sure there are records in tblItinerario which satisfy the condition given?

---