I started working with toad data point automation the other day and I really like the result and ease of use. Now I would like to take this to the next level.
I execute the same sql script 10 times to generate 10 identical reports that I distribute to 10 different vendors. Every time I run the script I have to update the where clause which use the IN operator.
I was able to successfully automate repot 1. Which means I have 9 more identical automation scripts to create.
How can I use one single automation script to generate all of my 10 reports.