tkbr0wn,

after getting nowhere I used your SQL and it took 24 seconds to run. I replaced the cursor in the stored proc and used your method. Will run...

Thanks for your insight. Sorry about being vague. Basically the sp gets ids required to update another table while processing through the entire recordset. I noticed something...

Hi Jeremy,

I'm currently working on SQL Server 7 using a cursor sp that is killing my DTS. I'm looking to rewrite this sp maybe using rowcounts, but before I...

Hello,

As I was saying before this procedure does not work

Public Function ExecuteSP(sProcName As String, ParamArray aParams()) As ADODB.Recordset

Dim objCMD As ADODB.Command

Set objCMD = New ADODB.Command

With objCMD

.ActiveConnection = Conn

.CommandText = sProcName

.CommandType...

Good article, I found it very interesting. These examples are really good but only address one procedure at a time. Taking the OOP methodology I'm in the process...

FYI. I fixed the issue. Since I'm using apartment threading which is not compatible with the Oracle driver. My job scheduler continues running. Fixed this issue...

I found this out on Friday.

Test my package through the scheduler. I noticed something interesting. The job ran fine through the scheduler. However the scheduler keeps running...

In addition I just created a test package pulling data from Oracle using Microsoft for Oracle driver. Ran the package without the scheduler and the package ran for 3...

The user of the scheduling is the sa user which points to a generic user call SQLExecutive from a different domain. It was such a coincidence that once the...

Hi Everyone,

I went back to the client and adjust business rules. Now the data contains the right relationships and the way the data was being stored is no longer...

Did you look at Rapid SQL, it basically along the same lines as Toad. I guess based on market demands the producers of Toad will start incorporating into other...

No Way! This is unbelievable. It's kinda of like getting a belated Christmas gift. Never having to do this type of functionality before, it became a quest...

Wow is right, you're fast and Thanks. I'll test out the code and provide feedback. Do you mind if I need to modify the sp.

Thanks

JMC

Interesting, but did you ever consider a blob. The reason, when I did a migration to Oracle9i, there were fields that were VARCHAR5000, however when I ran into or...

Sorry, it took so long to reply and close this item. Unfortunately I can not access the server and implement anything on the database servers. My work around...