Well, I was not as satisfied with rownumber over order-by ..

I needed to enumerate 22mio records and over 3h didn't know wheather I'm on half way or no-way.

So I used an alternative:

1. original table: T(n int, data char..) with 22mio records

2. copy top 0 into T' from T

3. alter table T': make n as autonumber

4. insert into T' from T

if 4th step fails because of transaction lenght, use some criteria on T to only get

part of data, i.e. year(date), etc.

Worked fine.

Grega