CREATE TRIGGER [dbo].[TrigT3]
ON [dbo].[T2]
FOR UPDATE
AS 
BEGIN
SET NOCOUNT ON;
UPDATE t3
SET t3.FT3toupd= t3.FT3toupd+ ‘abc’
FROM dbo.T3 t3
INNER JOIN dbo.T1 t1
ON t1.T1ID = t3.T1ID
INNER JOIN INSERTED i
ON i.T1ID = t1.T1ID 
WHERE (NOT (t3.T3ID IS NULL)) AND (NOT (t3.FT3_1 IS NULL)) AND (t3.FT3_1 <> '') 
AND (t3.FT3_5 = 2) AND (i. FT2_Conditional = 1))
END

quote:

---

Originally posted by visakh16

seems like what you need is this?

CREATE TRIGGER [dbo].[TrigT3]
ON [dbo].[T2]
FOR UPDATE
AS 
BEGIN
SET NOCOUNT ON;
UPDATE t3
SET t3.FT3toupd= t3.FT3toupd+ ‘abc’
FROM dbo.T3 t3
INNER JOIN dbo.T1 t1
ON t1.T1ID = t3.T1ID
INNER JOIN INSERTED i
ON i.T1ID = t1.T1ID 
WHERE (NOT (t3.T3ID IS NULL)) AND (NOT (t3.FT3_1 IS NULL)) AND (t3.FT3_1 <> '') 
AND (t3.FT3_5 = 2) AND (i. FT2_Conditional = 1))
END

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by Kristen

"My syntax appears to be correct as the trigger is created but it does not fire if dbo.T2.FT2_Conditional is = True"

Trigger needs to be on [T2] table then, not on [T3]

---

quote:

---

Originally posted by nigelrivett

>> if dbo.T2.FT2 = True
You mean you want to trigger the update when this is changed to true?
If so then the trigger needs to be on T2.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---