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.