<div>
Thank you.<br />
<br />
I used a different example from the page you sent and it works great.
</div>


Thank you.

I used a different example from the page you sent and it works great.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have two tables, Jobs &amp;&nbsp;GoodsReceipts. In Jobs there is an ActionDate (datetime) column which I need to compare with GoodsReceipts column Date (datetime) and if they differ, update GoodsReceipts with the new date.<br />
<br />
I am sure the answer is very simple but I am having one of them days :(<br />
<br />
I'm using MS SQL SERVER 2008.<br />
<br />
Thanks,<br />
<br />
<br />
David
</div>
</div>


Hello Experts,

I have two tables, Jobs & GoodsReceipts. In Jobs there is an ActionDate (datetime) column which I need to compare with GoodsReceipts column Date (datetime) and if they differ, update GoodsReceipts with the new date.

I am sure the answer is very simple but I am having one of them days :(

I'm using MS SQL SERVER 2008.

Thanks,


David

Compare &amp; Update Dates In Two Tables

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Compare &amp; Update Dates In Two Tables

Compare & Update Dates In Two Tables