Sql updating table from temp table

You can use these temporary, memory-resident tables to test the effects of certain data modifications and to set conditions for DML trigger actions.

You cannot directly modify the data in the tables or perform data definition language (DDL) operations on the tables, such as CREATE INDEX.

The preferred storage for large data is to use the varchar(max), nvarchar(max), and varbinary(max) data types.DML trigger statements use two special tables: the deleted table and the inserted tables.SQL Server automatically creates and manages these tables.Updating this to an INNER JOIN, and adding a separate INSERT should resolve your issue if I'm understanding it correctly.are metadata about the data within a table and they're created and updated on a column-by-column basis, not on the entire table.