Viewing 15 posts - 25,681 through 25,695 (of 26,487 total)
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...
July 12, 2007 at 7:06 am
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...
July 11, 2007 at 11:34 pm
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...
July 11, 2007 at 1:50 pm
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?
July 11, 2007 at 10:36 am
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...
July 11, 2007 at 10:20 am
Also, you may want to put an index on this # temp table: #temp_map_city2zip.
![]()
July 11, 2007 at 10:14 am
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...
July 11, 2007 at 10:09 am
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...
July 11, 2007 at 9:58 am
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...
July 11, 2007 at 9:50 am
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...
July 11, 2007 at 9:36 am
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...
July 11, 2007 at 9:20 am
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...
July 11, 2007 at 7:28 am
David, Ignore who?
![]()
July 10, 2007 at 8:09 pm
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...
July 10, 2007 at 6:54 pm
Viewing 15 posts - 25,681 through 25,695 (of 26,487 total)