Can a View or SP include tables from multiple databases?

[dgillz]

Is this doable? I am envisioning something like:

SELECT balance from database1.glbalfil.balance
UNION SELECT balance from database.glbalfil.balance....

The idea is to get GL account balances from multiple companies (databases) to facilitate a consolidated financial statement.



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[hooggie]

Yes you can do this

e.g.

select 'Company 1' as Company, GLCODE, AMOUNT from DB1..SQLTABLE

union all

Select 'Company 2' as Company, GLCODE, AMOUNT from DB2..SQLTABLE

 

[Crowley16]

you can get them from different servers as well, if the server is added as a linked server, and you use 4 part naming scheme...

--------------------
Procrastinate Now!