asked on

combining Microsoft SQL queries

I need to combine about 12 queries into 1, so I can update about 100 databases faster. The queries are attached.

THanks
Run-in-query-analyzer-4-4-5.zip

Gregory Miller

Can you explain what you mean by combine them? SQL Queries should be able to be appended to each other and run all at one time. They will run asynchronously one after the other. The next one will not run until the previous one finishes. Is this what you mean?

AielloJ

indyit,

With the number of different tables involved, getting it into 1 query isn't going to happen. Can you tell me more about what you're trying to accomplish? Why are there 100 databases all requiring the same information? Are these databases on a common network?

AielloJ

indyit

ASKER

essentially I just need to be able to 'manually' run this query on each database that is updating a software package with a 'new' version. it doesn't mater if they run sequentially or not...as long as I physically don't have to keep selecting the next query to get the database updated. onnce it starts to run I can move on to the next database. this is how I normally do it, but my SQL guy is not available

indyit

ASKER

Is this something someone can physically do? combine the queries and email me the query?

ASKER CERTIFIED SOLUTION

Gregory Miller

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

indyit

ASKER

wow simple and elegant....simple for you , but a real solution for me...

Thanks!