SQL Updating only from previous day
<p>I have loaded all the content from TableA where TableA has a field called </p>

<pre><code>CreatedDate(DateTime)
</code></pre>

<p>I have copied only the content of this table which are of actually usefulness.</p>

<p>Rather than using SQL Agent to schedule a job to copy this table everynight, I would like to append the data and only insert any new data added and perhaps do some updates that may have been affected in last day.</p>

<p>Just wondering whats the best way to do this taking into account we already have the initial data loaded but just want to append new data each day.</p>

<p>I was thinking about doing the following SQL in the where clause:</p>

<pre><code>CreatedDate between getdate()-1 and getdate()
</code></pre>

<p>Is this the best way to do it?</p>

<p>Thank you</p>