Since you don't have a Identity column here you might have to use a row number to join the other columns back in.

Generally you could just split the information accordingly in your lookup tables and do it like this:

SELECT DISTINCT col1, col2, col3

INTO lookuptable1

FROM lookuptable

To prevent inserting duplicate rows you can also specify UNIQUE Constraints like this:

CREATE TABLE lookuptable1

( ID int IDENTITY(1,1) PRIMARY KEY

, col1 nvarchar(50)

, col2 nvarchar(50)

, col3 nvarchar(50)

CONSTRAINT [uqLookuptable1cols1_3] UNIQUE (col1, col2, col3)

)

Or if the table already exists:

ALTER TABLE lookuptable1 ADD CONSTRAINT [uqLookuptable1cols1_3] UNIQUE (col1, col2, col3)