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.

I partly agree with that, but some else has heaped some fuel on it as well (not you, Jeff).  I got some good info that could come in handy.

And the flaming starts again.  I think the professionalism of this site is starting to wane.