Thanks George,
I made the changes, and overall it made about 45 second improvment. (that is good!)
As far as retooling this proc without Cursors, I welcome any Ideas! This Stored proc produces the extract for a major companies financial reports. When you understand the complexity of these...
The SP simply did not return anything. The Catch was not executed. Nothing. But I found the answer! TIMEOUT!
I had a time out of 3 minutes.... Changed it to 6 Minutes and voila! It works just fine.
SQL Stored Procedure used for Financial Reporting extracts runs fine standalone, but when called by VB2010 fails intermittantly, at different locations (lines where failure occurs are highlighted below). When the @GLClass parameter results in less than 1000 records, the stored proc works just...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.