Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

combining Microsoft SQL queries

Posted on 2013-12-28
6
275 Views
Last Modified: 2013-12-28
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
0
Comment
Question by:indyit
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39743791
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?
0
 
LVL 13

Expert Comment

by:AielloJ
ID: 39743795
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
0
 

Author Comment

by:indyit
ID: 39743812
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:indyit
ID: 39743822
Is this something someone can physically do?  combine the queries and email me the query?
0
 
LVL 11

Accepted Solution

by:
Gregory Miller earned 500 total points
ID: 39743874
They are only text files...

unzip them all into a single folder called c:\batch\
run the command Copy c:\batch\*.sql c:\batch\OneBigQuery.sql

This will combine all files into one for you and you are all set.

MAKE GOOD BACKUPS OF YOUR DATABASES BEFORE YOU DO THIS...
0
 

Author Closing Comment

by:indyit
ID: 39743931
wow simple and elegant....simple for you , but a real solution for me...

Thanks!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question