Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yxiong
Starting Member
4 Posts |
 Posted - 2002-03-19 : 17:20:06
|
| Hi all,I am new here and I need help! I am writing a web app with SQL Server 2000 (Prof. edition) as my database. SQL Server is running on a Windows 2000 machine. The ASP web app will reside on an intranet. Unfortunately because of the way that our company is set up there will be 4 databases representing a separate region of the country. My question is: What is the best way to collect data from 4 separate databases to create a single report?Any help would be greatly appreciated. Thanks!--yx |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-19 : 18:08:09
|
| You could just do a UNION in your select to grab data from each database. That is probably the easiest way.Damian |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-03-19 : 18:30:07
|
| Hi!You might want to consider making views to assemble the data from all databases for reports you will be running regularly. That way you will only have to query the view like a regular table, not like four separate tables from four separate databases.Sarah Berger MCSD |
|
|
|
|
|
|
Best Practices