|
|
Posted by Doug on 03/07/06 17:14
i'm not a huge fan of the method of group number assignment. seems
pretty inefficient to do a row count every time.
Try this;
select distinct left(c1.fname,1) as fname, left(c1.lname,1) as lname,
c1.ssn into tmpgroups from tu_people_data
Using SQL, add a new column to tmpgroups which is an identity column
named tu_id
I'm a little puzzled on the business logic. It looks like the records
are identical if the ssn is the same, and the first letter of first
name OR first letter of last name is same. Is this what you want?
Navigation:
[Reply to this message]
|