This is my first crack at using the automation tool in Toad so please bare with me. Anyhow, I’ve written a query for a report my customer would like run every month or so.
For argument sake, assume I had the following query:
SELECT * FROM ARTISTS
WHERE ArtistID IN (insert long list of IDs which are alphanumeric)
My customer will be providing me with a list every month or whenever she wants to run the report so this can’t be hard coded into the query.
How can I make the query run every month, and use the different ArtistIDs or variables? Also is there a way that this could be done in reverse from excel?
I’ve looked at the following link:
because I’m on v4.3 I don’t see a lot of the screens she shows in her illustration. Would appreciate the help.