Jeff Moden (5/17/2009)
.. if, for some reason, you cannot use IDENTITY and you're stuck with SQL Server 2000 or less which prevents the use of ROW_NUMBER and the like, then the "quirky" update Flo used is absolutely the fastest method available.
Heh :laugh:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi