SQL plus running multiple queries

Question

I have 12 queries to run, but can not run at the same time. I would like to start the first query, then as soon as it completes the next query begins, when it completes the third query starts and so on. Want this to be automatic. Each query writes a txt file. Thanks

What do you have so far? Do you have any issues running anything in the current format you have? What have you tried so far? — Nope
– Nope, Commented Oct 4, 2010 at 13:32

vc 74 · Accepted Answer · 2010-10-04 13:35:24Z

2

Seems to me like you just have to create a script and call that script:

@query1.sql
@query2.sql
...

Or am I missing something?

answered Oct 4, 2010 at 13:35

vc 74

38.3k7 gold badges80 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marcel de Kleine · Accepted Answer · 2010-10-04 13:38:52Z

0

Paste them all in 1 file with a GO statement between should do the trick.

answered Oct 4, 2010 at 13:38

Marcel de Kleine

1461 silver badge11 bronze badges

Collectives™ on Stack Overflow

SQL plus running multiple queries

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related