Im tryuing to clean out some mess in my DB. When i upgrated nobc the first couble of times i deleted everey files including the setting.txt so every time there was added some double features in the DB. including doublets of countries.
I´m trying to delete every dublet there is.
in the meantime, some of my customers have choosen a version of their country that is different from the majority of mu customers.
So now i have my country represented with four dif. country id´s.
I have nov deleted most of the country dublets.
I can´t delete the ones that have been choosen by customers.
If i were to write a query that were to replace every instance of countryid 4752 with 294 in the table dbo.adress how would i do that. :-) ??