Unanswered: Update single table from multiple tables in various databases
I would like to INSERT data into a single table from a table in other databases on the same server. The problem comes in where the number of external databases are not consistant. I have written a query that works well, but the query grows with every database addition. At present I "replicate" 12 tables (12 target tables form 20 databases with 12 tables each). What I would liek to do is store the source infomation in a table and call the info for each run of the query. In this way I can manage the table only.