SQL Server - INSTEAD OF UPDATE Trigger

[Tomehzg]

I am wondering if it is possible to commit the Inserted table to the database after making modification within the INSTEAD OF UPDATE trigger. I know this is possible with an insert trigger using temporary tables.\[code\]SELECT * INTO #Inserted FROM InsertedUPDATE #Inserted SET Column = SYSDATETIME()INSERT INTO SomeTable SELECT * FROM #Inserted\[/code\]I know that something like this can be done in MySQL, but I am unsure how I would translate this behavior into SQL Server.\[code\]UPDATE SomeTable x, TempTable ySET m.Column = y.ColumnWHERE x.TableId = y.TableId\[/code\]As an after thought, I remember reading that temp tables have significant performance issues in previous versions of SQL SERVER, would these statements be possible to do all with a 'derived' table or entirely in memory operation?