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/

• Next in forum: Re: ORDER BY in VIEW not working
• Prev in forum: Re: itzik ben-gan
• Thread view: Re: itzik ben-gan

[Reply to this message]