stored procedure not returning data

what I have given as an input ...

qrydeliveryYearwise=paste("exec pcpndt_041017..[FormFRajOtherState_ForChart] '101','3','1','0','','01/10/2017','01/10/2017'")

what I have got as an output...
<0 rows> (or 0-length row.names)

could someone please guide me through this problem

You need to provide more information about your code and what you are trying to accomplish. If I copy the code you provided directly into R and run it, I get a variable named qrydeliveryYearwise which is a character vector with one element containing all of the text inside of the paste() function.

Please take a look at the post in the following link that explains how to post a Reproducible Example, which will make it much easier to help you.

Thanks for your concern, I have got it , all I had to do just add the SET NOCOUNT ON to my stored procedure and it was good to go, appreciate your concern though

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.