Is there no choice but to add multiple 'excute query capacities?
The expectation from Execute Query is that it will return a result, which can be tricky to manage if one instance of the activity allowed multiple queries.
There are a couple of options to handle this.
- You may either add multiple activities with one query each, or
- Write a stored proc or function to do complex stuff on the database side and call the SP or function from UiPath.
thank you ash
If you decide to use the 2nd method suggested by @RPAForEveryone, then you can refer to solutions in this thread SQL Stored procedure Passing Parameters To fetch particular records to execute your Stored-Procedure via UiPath and get the DataTable from th Database.
Thanks so much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.