Hello team,
I need your help with the following situation:
For a team project, I need to run 2 queries:
- the first query is run in TOAD and will display a fairly small list of clinical studies and their depot locations
- the 2nd query is run in Microsoft SQL Server. Normally, this query is run manually for each of the clinical studies and each depot location that appear as results for the 1st query. I tried running this 2nd query in the whole DB and then use Alteryx to filter only for the clinical studies and locations displayed on 1st query; however, I was told this query blocks the DB and so I should stop running it.
How can I configure the Alteryx workflow to make the 2nd query run by automatically "selecting" the results from the 1st query instead of running it in the entire DB and then use the filters?
I tried configuring the MSS connection to RO mode outside of Alteryx but I don't have admin rights on my computer so it can't be done. Is there another way to use the MSS connection without blocking the entire DB?
Thank you!
Kind regards,
Ioana
