This:

UPDATE dbsource

SET @columnname1 = dbref.Amended_SW_Manufacturer,

@columnname2= dbref.Amended_Product_Name

Is a funny way of doing variable assignment. There is no indirection, if that is what you thought.

Another problem with your UPDATE is that one target row matches many source rows. This means that the result of the UPDATE is not deterministic.