Found this in my virtual briefcase but I never used it.  It is in the script library by Klott

Might be helpful.  Main thing is getting a good zipcode database.

Some are fairly...

I've got a where clause that I am incrementing in a loop to select the primary key.

where t1.objectid >= @lower and t1.objectid <= @upper

The problem is my table is so...

The statement you provided only updates 1000 rows out of my table.

I am new at SQL so I am not sure if I need to include anything else. 

I do...

My trouble seems to be how to do it for every 1000. 

 Do you put the rowcount  inside the loop or is the loop not necessary anymore?

I put the Set Rowcount...

Hi Steve,

I am still having trouble with this query.  I tried a number of different ways to use the while loop, but it still runs for over 10 hours and...

Well that was easy - I'm smiling again - Thanks!