this kind of output my SP giving me, and I have used print statement of SQL to print this output,
but when I call SP with the correct input Parameter then it's not returning the result.
Discussion posts and replies are publicly visible
Yeah we can't really tell what you might be doing wrong if you don't provide the code snippet you're using to try and call your SP. And maybe also an anonymized screenshot of the SP (or at least its first few rows or something).