Hi,
I have an SQL Stored Procedure (Without Parameters) for which I want to return data in Excel.
Currently I am using this link as guidance >
http://codebyjoshua.blogspot.in/2012...er-stored.html
http://www.sqlservercentral.com/Foru...54-2799-1.aspx
However, I am unable to get the data to be returned.
Below are the necessary details -
Database Name – ZZ_Common
SP Name – Update_Vol
Can anyone help me with this?
Cheers!
Deep Dave
What code did you try and what happened? It would also be helpful to see the SQL for the SP.
Remember what the dormouse said
Feed your head
I tried it using 2 methods -
1) Using MS Query - I did it everything as per this link - http://codebyjoshua.blogspot.in/2012...er-stored.html
{CALL ZZ_Common.dbo.Update_Vol} and removed all the (?, ?, ?) as I had no parameters.
2) I also used FROM SQL SERVER, where on the Connection Strings Dialogue Box I Selected Command Type as SQL and Command Text as EXECUTE Update_Vol
Stored Proc -
It returned this error
Please Login or Register to view this content.
Capture.GIF
However, the DB & its Tables are all working fine..
Last edited by NeedForExcel; 05-13-2015 at 02:07 AM.
Which stored proc is that? If it's Update_vol it appears to call itself?
I am sorry, I don't use SQL too much.. Here it is -
Please Login or Register to view this content.
Last edited by NeedForExcel; 05-13-2015 at 03:04 AM.
What is Return Value when you run that in SSMS?
The Return Value is Zero!
Does the sproc actually execute even though you get an error?
Actually when I use the MS Query to get the data, the Store Proc seems to execute as I get a Pop-Up saying the Query Executed Successfully, but surprisingly no data is displayed on the grid.. Using the other way, it does not seem to work..
What data are you expecting, the stored procedure returns Zero
The Stored Proc Returns a Value Zero.. It isnt returning Null.. I am expecting that Zero to be displayed in MS Query/Excel.
You're only seeing Zero in SSMS as you're asking for a return value, if you just execute the stored procedure you won't see anything - it won't have a return value.
Try using:
In msqueryPlease Login or Register to view this content.
I am not sure whats really is going wrong as I am very new to SQL..
All the 3 SPs that I have, Update some Data.. Is that the reason why nothing is being returned?
Last edited by NeedForExcel; 05-13-2015 at 06:48 AM.
It's because the Stored Procedures have no Return value, you need to add one if you want to return something
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks