Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

joining multiple databases in one Sr... Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 9:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 1, 2013 6:10 AM
Points: 3, Visits: 20
hi guys
I need help with an issue that I've got
scenario
I have multiple branches around australia with each branch having it's own db
each db contains the same information required for the branch itself
e.g.
branch a Has first name / last name
branch b has first name / last name
of course the fields have their own unique entries
e.g.
James in branch a
John in branch b
objective
creation of report in ssrs with a join of multiple databases
is it possible using an expression or anything else at all
thanks in advance to who ever can help me
Post #1467434
Posted Wednesday, June 26, 2013 8:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,067, Visits: 11,906
duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1467443-1633-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1467697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse