Add a unique key value to every row in a set that is not identity

[tstocksql]

Hi,
I would like to step through every row in an existing record set, not using cursor preferably, and add a key value to one column. When I tried this with cursor it was slow. Is there a better method?

 

[mrdenny]

Your two options are a cursor or to add an identity column. Since you are looking to put a different value in each record you need to process each record one at a time.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[tstocksql]

WOW! That was fast! Thank you Denny.

Will DTS trigger an identity column on an import?