Can I get some help in writing a stored procedure. Essentially I have a table 'BarcodeTypes' and I want to update a field called 'NewName' in this table. I also have another table called cte which has a column with the same name 'NewName'. There is another column in both these tables called Type which containt the same values in both tables.
So I want to update the 'BarcodeTypes' table with the values from the 'cte' table.