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...

Sergiy,

And you still refuse to provide the citation in New Zealand Law that prohibits the use of BR.  What, are you having problems finding the facts to back up your...

David, Ignore who?

No, David is talking tolerances.  Depending on the scale, the tolerance is + OR - a specific % or weigt.  This tolerance will be dependent on the scales usage and...

In Object Explorer in SSMS, Right Click on the Database, and select Generate Scripts.  The wizard will walk you through generating what you are after.