query other databases from the information in another database

• pjuster

  Newbie

  Points: 7

  More actions

  March 25, 2013 at 11:06 am

  #99811

  Hi,

  I have a database called databaseA with a table called, otherdbs with two columns

  server databasename

  server1 parts

  server2 parts

  I would like a query that queries databaseA and table called otherdbs, which then uses the server and databasename to issue another query on each of the databases.

  Apologies for the lack of details, is this possible? any hints on where to start would be brilliant.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 25, 2013 at 11:07 am

  #1600438

  pjuster (3/25/2013)

  ---

  Hi,

  I have a database called databaseA with a table called, otherdbs with two columns

  server databasename

  server1 parts

  server2 parts

  I would like a query that queries databaseA and table called otherdbs, which then uses the server and databasename to issue another query on each of the databases.

  Apologies for the lack of details, is this possible? any hints on where to start would be brilliant.

  Yes, using dynamic sql along with linked servers.