I need to run a whole lot of separate processes and save each run to a text file for our auditors. Is there a method using SQL where I can define the filename and have it save the file automatically without prompting me each time?
Then I can just make a temp table of the criteria and have it just crank away.