I have a small app that inserts data into the database.
I have a something like this
dbo.system.table1(col1, col2, col3) and table2(col1) (table2.col1 is just one single row).
What I want to do is insert the table2.col1 into table1.col3 when a new order is made.
Also the table2.col1 updates twice a day, so every time a new order is made with table1 I need to keep the old table1.col3 changes.
CREATE TRIGGER dbo.TR_CHANGES
SET table1.col3 = (SELECT col1
WHERE table1.col3 = table2.col1)
But it ends updating col3 for all rows.