stored procedure not returning data

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.