Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Question Unanswered: Update single table from multiple tables in various databases

    Hi,

    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.

    Please assist. Thanks.

  2. #2
    Join Date
    Aug 2009
    Posts
    3
    You could write a trigger on the table in every database to store the value into the single table.

  3. #3
    Join Date
    Aug 2009
    Posts
    2
    Hi haden213. Thanks. That is an option. Let me investigate.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •