Skip to content
Advertisement

I need to migrate data from one old table to a new table by storing appropriate CityId instead CityName

I’m migrating data from one table to another table in SQL Server, In this process what I need to do is “I have 10 columns in old table one column is ‘CityName’ which is varchar and in the new table, I have a column ‘CityId’ which is an integer. And I have other table which has data about city id and names. I need store the appropriate cityId in new table instead of CityName. Please help me. Thanks in advance.

Advertisement

Answer

Below should give you an idea, you need to inner join to your look up table to achieve this.

Output:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement