Hi,

I've been given a spreadsheet to import into a database and need to normalise the data a bit. The source data when imported looks like this:

Group   Code  description
AAA     001    Desc 1
AAA     002    Desc 2
BBB     003    Desc 3
BBB     004    Desc 4

(Of course the actual data makes more sense than those values I've put in.)

I need to separate the Groups out into one table with a primary key and and the Code, Description and a Foreign Key value (pointing back to the Group).

I use uniqueidentifiers as keys so was trying this:

INSERT INTO BenefitCodeGroups
SELECT DISTINCT NEWID(), Group
FROM BenefitCodesImported

but of course that doesn't work as I'll get a record for each distinct combination of NEWID() and Group.

Who can help wake my brain up on a Monday morning?