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:

          Begin

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

               Insert statement;

               Select B from xyz;

          End

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,

Swaroop

replied

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.

Regards,

Swaroop

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