I am glad to here that things are running smoother and faster.  I have setup a sandbox with the data you provided, but I haven't had a chance yet to...

Hadn't heard that one.  Must have been before I joined the site.

The first example I gave you fails even with an order by in the statement.  Like I said, it appears to be a bit flaky and inconsistant.  I have used...

The most obvious error I have seen is actually with two small tables with 5 or 6 columns (don't have the data in front of me) and 19 rows in...

Unfortunately, some keep alluding back to it in other threads.  Yes, I have been involved in the BR thread, but I have been very good about leaving my comments in that...

I got your data, ddl, and current procedure.  I'll see what I can do with it tonight at home. 

Any one else want to jump in, please do as you may...

Could you post the DDL for the tables used in the procedure and some sample data, perhapes enough for 3 quick iterations of representative data?

One last change to suggest.  In your procedure you are using @@IDENTITY, you may want to change that to SCOPE_IDENTITY().  If, during your processing an insert to another table with...

Also, you may want to put an index on this # temp table: #temp_map_city2zip.

You can define the identity column in the create table when creating the # temp tables, then you won't need the IDENTITY() function in the insert statement.  This will also...

Check who the owner of the jobs are.  Had an issue at my last employer with processes working manually, but failing as a scheduled job.  I got around this by...

It is desireable to eliminate cursors if possible.  Sometimes, however, they are the proper choice for a specific task.  Not having your data handy to test against, it is difficult...

Also,  If you have to use a cursor (no one comes up with a set-based solution), you should try creating the the two # temp tables you use inside your...

Yes

There is probably a set based solution to this process, but I don't see it yet.  One change I think may help is in the declaration of the cursor.  Try...