I have a very large Stored Procedure in MSSQL2000 that im calling and giving it 4 parameters, and returning Many Parameters, that are populated by calculations within the same stored procedure, the problem is if i run the sproc for the first time that day using
{CALL SPROC_GETVALUE('1/1/2003', '1/30/2003', '10', 'DFW')} it will throw an error saying
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
But if i call it using
EXECUTE SPROC_GETVALUES '1/1/2003', '1/30/2003', '10', 'DFW'
then it will run just fine and also
if i comment out sections of the sproc and run it one step at a time, then if i use te first CALL again it works fine?
{CALL SPROC_GETVALUE('1/1/2003', '1/30/2003', '10', 'DFW')} it will throw an error saying
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
But if i call it using
EXECUTE SPROC_GETVALUES '1/1/2003', '1/30/2003', '10', 'DFW'
then it will run just fine and also
if i comment out sections of the sproc and run it one step at a time, then if i use te first CALL again it works fine?