Viewing 6 posts - 1 through 6 (of 6 total)
I finally figured it out. I just had to make sure my open was called in the same transaction the work was being done in. (Before I was...
August 11, 2006 at 11:41 am
Nope, they're just a couple inserts and an update.
August 10, 2006 at 10:28 am
The cursors are not nested; each one finishes before the next one starts.
August 8, 2006 at 7:39 pm
He's probably also truncating Table B.
You can have Enterprise manager generate the drop and add foreign key constraints with a little fiddling with the "Generate SQL Script ... " feature....
August 8, 2006 at 2:23 pm
I ended up making a temp table and adding an index to it. It sped the query up enormously.
It doesn't quite solve my underlying problem, though. What's the...
June 1, 2006 at 11:49 am
How many rows are in each table? Are being inserted?
About 267,000 rows are being inserted.
How are you running it when it takes 6 hours to run?
Inside a stored procedure...
May 31, 2006 at 5:32 pm
Viewing 6 posts - 1 through 6 (of 6 total)