Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fixed Query - Not returning selected statement with exec SP

Dear All,

Something strange happening with my query template, not sure why. I guess i am missing something here.

Problem statement:

SP with following logic:


               Set @a = (Select.....);

               Insert statement;

               Select B from xyz;


In SQL QT with fixed mode:

          Exec SP

I am not able to see result of Select B from.....query, it just gives me a blank Rowsets node. Any pointers??

Thanks in advance.

Best Regards,



Hi All,

Got the solution. 

Use "Set NOCOUNT on;" in the procedure and set it back to off after begin and before last select.

Thanks for replying.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question