CREATE TRIGGER SOMEAUDIT
ON DATBASENAME.DBO.SOMETABLE
AFTER UPDATE,INSERT,DELETE
AS
  SET NOCOUNT ON
  
  BEGIN
  
    Insert DifferentDatabase.Dbo.SomeOtherTable
    field1,
    field2,
    field3,
    ....
    
    SELECT DIFFERENTDATABASE.DBO.FIELDA,
           DIFFERENTDATABASE.DBO.FIELDB DIFFERENTDATABASE.DBO.FIELDC
           
    FROM   Inserted
           INNER JOIN SOME3RDTABLE
             ON Inserted.field1 = SOME3RDTABLE.B
           INNER JOIN SOME4THTABLE
             ON SOME3RDTABLE.C = SOME4THTABLE.D
    WHERE  SOME3RDTABLE.Z = 'bleh'
  END

quote:

---

Originally posted by X002548

Weel do a showplan, but I believe the WHERE Predicate is applied before the join predicate

In any case, it doesn't make much sense in the first place

You don't reference inserted or deleted



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

---