Posted by SQL on 03/07/06 17:18

you can add the identity in one shot
select distinct identity(int,1,1) as tu_id,left(c1.fname,1) as fname,
left(c1.lname,1) as lname,
c1.ssn into tmpgroups from tu_people_data


http://sqlservercode.blogspot.com/

[Back to original message]