CAUTION! This script creates non-temp as well as temp tables.Please use on a test database! CREATE TABLE #MyTemp([NAME] VARCHAR(50), City VARCHAR(50))CREATE TABLE City(CityID INT IDENTITY (1, 1) NOT NULL, City VARCHAR(50))CREATE TABLE Names([Name] VARCHAR(50), CityID INT)INSERT INTO City(City) VALUES('LA')INSERT INTO City(City) VALUES('New York')INSERT INTO City(City) VALUES('Dallas')INSERT INTO #MyTemp([Name], City) VALUES('Graz', 'LA')INSERT INTO #MyTemp([Name], City) VALUES('Nick', 'New York')INSERT INTO #MyTemp([Name], City) VALUES('Mike', 'Dallas')INSERT INTO #MyTemp([Name], City) VALUES('Yak', 'Middle of NoWhereVille')INSERT INTO Names([Name], CityID)SELECT mt.[Name], c.CityIDFROM #MyTemp mtINNER JOIN City c ON c.City = mt.City--I'm assuming CityID is automatically generated by a IDENTITY or UUIDINSERT INTO City(City)SELECT City FROM #MyTemp mtWHERE NOT EXISTS(Select c.City FROM City c WHERE mt.City = c.City)select * from cityselect * from NamesDROP TABLE CityDROP TABLE NamesDROP TABLE #MyTemp
Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda>