That sounds disgusting :) I've never heard that word used like this before, LOL.

I'm doing this in SQL Server Management Studio, not in VFP so I don't think I can use INTO CURSOR.


>Just kinda spitballing here - if you want a unique ID per group, I'd prolly do this:
>
>

>Select group, count(*) from BenefitCodeImported group by 1 into cursor CntGroups
>
>INSERT INTO BenefitCodeGroups 
>SELECT DISTINCT NEWID(), Group 
>FROM CntGroups
>

>
>
>>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?