Calling Multiple SQL Stored Procedures at once
Currently working with a requirement that needs to execute 18 stored procedures at once. I am calling these in two sets (5 first/13 second) using parallel processes for each set.
At the moment I have 18 SQL connectors each with identical connection strings and the only differences are about 4 sets of unique input parameters across the 18 procedures.
Each SQL execute is followed by a GetTable() call to the corresponding lookup table.
Any recommendations?
***Edited by Moderator Marissa to update platform capability tags***