I have a stored procedure that recieves a 1,2,3, or 4(quarters of the year) and then returns the respected data in a table. I enter the quarter I want in the SQL Query Analyzier when running the stored procedure.
getSales being the procedure and 1 being the quarter
Is there anyway I could enter the qauarter I want in a text file and have it read in by the stored procedure???
Originally posted by Satya
What was the error you're getting?
Which version of SQL and SP used?
I am using SQL Server 2000 and the error I recieve is very vague.
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].