Viewing 8 posts - 106 through 113 (of 113 total)
The total time for my process now has gone from ~ 4:30 to ~ 1:00!
Now that's performance!
April 10, 2008 at 10:36 am
I've got it!
The problem was in the order of the set statements.
Because @currrange_start and @currrange_end rely on the value of @currfile, setting @currfile to the value of the current record...
April 10, 2008 at 10:27 am
Apparently the answer is in the details. Thanks again for spending time on this. Unfortunately, it's still not quite there.
The code seems to work correctly if I use...
April 10, 2008 at 8:45 am
Thank you for your thoughts and effort on this.
Your answer seems oh so close and it certainly is fast! However, it doesn't quite work the way I need it...
April 9, 2008 at 3:15 pm
Hi. I'm presently using this solution to my problem and it does indeed work. The only drawback is that it takes a long time.
This code bit is the...
April 9, 2008 at 10:17 am
That's it! Thanks.
April 9, 2008 at 9:29 am
If I understand the problem properly I think that this would work.
IDENTITY(INT,) AS pKey
FROM [YOUR TABLE]
This will give you a temporary table with pKeys
March 27, 2008 at 2:12 pm
Is it wrong to use code you don't understant? 😉
It'll take me a little while to figure out exactly what this does but it does indeed work.
Thanks so much!
March 27, 2008 at 12:57 pm