Multiple dataset problem
Hi,
I use TMSStoredProc and SP has multiple datasets. Besides, SP has some business logic and use Cursor to handle the logic. I tested to insert the records into physical table instead of #temptable in SP. I found it doesn’t insert any records into physical table. I found it needs to use "OpenNext" for trigger the action. But in MSSQL server management studio will return all datasets directly. How can I solve this issue that can return all datasets instead of use "OpenNext" to trigger?
I use TMSStoredProc and SP has multiple datasets. Besides, SP has some business logic and use Cursor to handle the logic. I tested to insert the records into physical table instead of #temptable in SP. I found it doesn’t insert any records into physical table. I found it needs to use "OpenNext" for trigger the action. But in MSSQL server management studio will return all datasets directly. How can I solve this issue that can return all datasets instead of use "OpenNext" to trigger?
Topic Participants
Timothy Lam
Volodymyr Klopkov