Run Queries in Parallel

[asaeed78]

I have a batch macro that creates sql statements from rows of an excel sheet and then runs the sql against my db.

each row of my excel defines a single sql statement.  At the moment the queries are run in sequence.  I want all the queries to be run in parallel.

Is there a way to achieve this in a single Workflow?

[KGT]

The Batch Macro will run in sequence. That is how it's designed. So, changing the structure of your workflow is going to be the solution.

You could have the batch macro create all the statements, and so the output of the Batch Macro is each of the statements, and then pass them all at once to the DB. If you want the outputs to be separate though, then you will need to have separate streams.

The other Out-of-the-box thought I had was having the statements write to a temp table, so that way your batch macro is just passing the statements, not waiting for results, and then call the temp table afterwards.