Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple database select

Status
Not open for further replies.
tmanportland

tmanportland

Programmer
Oct 23, 2003
1
US
I have multiple databases all with the same structure. What I want to do is query all databases at the same time. My query works fine if I only attempt one database. Any suggestions on how to reference multiple data files?

Thanks
 
Status
Not open for further replies.

Similar threads

joeb007
  • Locked
  • Question
select statement :sybase getdate
Replies
1
Views
72
blom0344
blom0344
Rubicks
  • Locked
  • Question
Time Dimension With Multiple Sets for Different Fiscal Year Definition 1
Replies
1
Views
69
RiverGuy
RiverGuy
misscrf
  • Locked
  • Question
SQL 2005 Database Diagram in Visio 2003?
Replies
1
Views
29
mrdenny
mrdenny
M8tt
  • Locked
  • Question
Measure Showing multiple decimal places 1
Replies
2
Views
47
M8tt
M8tt
shandads
  • Locked
  • Question
Multiple Time Dimensions SQL 2005
Replies
2
Views
28
MDXer
MDXer

Part and Inventory Search

Sponsor

Back
Top