<div>
When I insert the data in my main application it will go into two tables. &nbsp;A combination of data from those two tables will need to be inserted into one table in a different database. &nbsp;It doesn't look like this handles that? &nbsp;Can you give further explanation?
</div>


When I insert the data in my main application it will go into two tables.  A combination of data from those two tables will need to be inserted into one table in a different database.  It doesn't look like this handles that?  Can you give further explanation?

<div>
Do the two inserted rows have a parent-child relationship? &nbsp;It's probably the primary key of the single table on the other database. &nbsp;Put the trigger on the second table to receive the insert (should be the child table) and the trigger I described should work. <br />
<br />
If not, please post the structure of the three tables so that I can better understand. 
</div>


Do the two inserted rows have a parent-child relationship?  It's probably the primary key of the single table on the other database.  Put the trigger on the second table to receive the insert (should be the child table) and the trigger I described should work.

If not, please post the structure of the three tables so that I can better understand.

<div>
<div class="content wysiwyg-content">
I am trying to write a trigger that will allow me to insert data into a SQL Server database table once data is added to the first SQL Server Database. &nbsp;My problem is that the data needed for the second SQL Server database is in two separate tables in the first SQL Server database? &nbsp;How do I accomplish this?
</div>
</div>


I am trying to write a trigger that will allow me to insert data into a SQL Server database table once data is added to the first SQL Server Database.  My problem is that the data needed for the second SQL Server database is in two separate tables in the first SQL Server database?  How do I accomplish this?

Is there a way to update a table in another SQL Server Database with data from a combination of two tables in the Main SQL Server Database with a trigger?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.