title: Create view from data accross multiple databases
body: <p>After some searching around i couldn't find a good answer that covers my issue.
  I am working on the consolidation of around 100 databases. The structure is the same and they are all on the same server. All the databases have a table with login information.</p>
  
  <p>We have created a core database with all the connection information from the other databases.
  Now we need to create a view in the core database that contains all the login credentials from all the databases. 
  This means we need to use a loop to go through all the databases and select the user name and password.</p>
  
  <p>Any ideas or suggestions are welcome</p>