Why??

Application requirement?

Reporting?

Deleting rows?

Deleting duplicates?

As previously asked, can you post the table definition, some sample data and the expected output so that we can make the query??

Also why are you generating those numbers?

what does this return?

Select max(rowcnt) as Total from dbo.SysIndexes where id = object_id('tablename') and indid < 2

It's late binding but at least it works .

How many rows are in the table?

Start a new thread for a new question, you will get more replies that way.

... and the classic answer : do it client side .

Is the logic of the update very complicated?

Maybe you could do something like

update table set.... where pk between X and Y.

In the client loop, then X becomes y + 1...

What are the min a max values??

datetime

between 1753/01/01 and 9999/12/31

smalldatetime

between 1900/01/01 and 2079/06/06

Don't forget to put it into a function so you can use it in a select.

Do you have values before 1900/01/01?

Same thing with russian roullete, many clicks can come before the bang. Anyways I can't stop you guys from doing that so good luck.

So be it... have other things to do on my vacations .

All that because I'm going on vacation???

Sould restart only when installing new service packs. Or when they don't respond and you can't find the reason why.