This is SQL Server - I have 3 rows of data in a single table based on location I want the data for a single field to match in all three locations e.g I have parts in three locations, location 1, 2, and 3 but the price for the part is different in each of the three locations, I would like to sync the price for all three locations
This is table 1 - fields include item number, location, price. e.g
item loc. price 123 1 0.1 123 2 0.2 123 3 0.3
My desired outcome is that location 2 and 3 will have the same price as location 1.