opss ... posted in the middle of editing

here is the general version:

 UPDATE [Table_Name]

 SET field1=i.field1,

       field1=i.field1,

        'Put Here all the fields of the table

        last_modified=getdate()  

 FROM inserted i

 INNER JOIN [Table_Name] ON...

Hi!

You are absolutely right!

but here is the correct version that works with multiple rows

 UPDATE [Table_Name]

 SET field1=i.field1,

field1=i.field1,

       'Put...