<div>
You can try:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42760751-1"><span>INSERT INTO newTable (col1, col2, col3)</span>
<span>SELECT column1, column2, column3</span>
<span>FROM oldTable </span>
</code></pre>
</div>


<div>
You can run a stored procedure as well to do this operation for you.
</div>


<div>
Well.<br />
The insertion must to be automatic, as soon the line is inserted at tb_individuo.<br />
Maybe an insetion trigger could do the job better.<br />
Any suggestion code on it?
</div>


Developer and Analyst

Eduardo Fuerte

<div>
Just one thing.<br />
<br />
The line to be inserted on Table2 must to be just the last line inserted on Table.
</div>


<div>
Then you can add a RowAddDate column in Table 1 and 2 and in trigger you can add a WHERE condition as:<br />
<br />
WHERE Col4 = (SELECT MAX(RowAddDate) from Table1)<br />
<br />
You can try this.<br />
<br />
Do you want only 1 record insertion? or all the records from table 1 to table 2?
</div>


<div>
Yes, just the last record...
</div>


<div>
Then you can definitely filter the last record by the date column.
</div>


<div>
Or else, you can have an IDENTITY column named as RowId in your table and then use the following logic to get the last record:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42760809-1"><span>SELECT TOP 1 * FROM Table1 ORDER BY RowId DESC</span>
</code></pre>
</div>


<div>
(Potentially silly answer) &nbsp;If both tables are in the same database then create a view that selects all from the first table. &nbsp;<br />
<br />
That avoids all the concurrency issues you'll have with two tables where if rows change in one then you'd always have to pull off changing it in the other.
</div>


<div>
@Pratik Somaiya answer is pratically running well.... testing...
</div>


<div>
Hi @Pratik Somaiya<br />
<br />
The job is done, thank you very much!<br />
<br />
@Jim <br />
I couldn't even try your suggestion... in a hurry...
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
Coul you point a way to automatically repicate an insertion on a table to another table by using MS-SQLServer?<br />
<br />
Accordingly to:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/12_w51/1407688/img_EE_001_201218.png" target="_blank" title="img001 (36 KB)"><img alt="img001" class="file-block lazyload" style="max-width: 633px;" data-src="https://filedb.experts-exchange.com/incoming/2018/12_w51/1407688/img_EE_001_201218.png" /></a><br />
The table <b>tb_individuo</b> receives an insertion sent by an web-service.<br />
<br />
Imediatelly after some columns values must to be replicated to the table <b>assistido</b>.<br />
<br />
Could you suggest a way to do that?<br />
<br />
Thanks in advance.
</div>
</div>


img_EE_001_201218.png

Hi Experts

Coul you point a way to automatically repicate an insertion on a table to another table by using MS-SQLServer?

Accordingly to:



The table tb_individuo receives an insertion sent by an web-service.

Imediatelly after some columns values must to be replicated to the table assistido.

Could you suggest a way to do that?

Thanks in advance.

Coul you point a way to automatically repicate an insertion on a table to another table by using MS-SQLServer?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.