tags:

views:

37

answers:

2

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

+1  A: 

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

@query1.sql
@query2.sql
...

Or am I missing something?

vc 74
A: 

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

Marcel de Kleine
that works, thanks