Quote:
UPDATE ReportTable
SET ReportTable.TransType = inserted.TransType
FROM SellTable
INNER JOIN Inserted ON SellTable.TransID = Inserted.TransID
You're updating
every record in the
ReportTable
table with one random value from the updated records.
There is presumably a connection between the records in the two tables? You will need to limit the records you're updating based on that join.
UPDATE
ReportTable
SET
TransType = inserted.TransType
FROM
ReportTable
INNER JOIN inserted
ON inserted.??? = ReportTable.???
;