Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2007-05-01 : 13:05:04
|
| Hi,I have table-A that is refreshed by our CRM application every one hour, refresh with current data in CRM. I have separate copy of the table-B for reporting tool. I have to check the table-A refreshed by CRM and update the table-B after hourly job. Since the table have very large volume of data,I need to check if there was any modification in last hour and only then modify those records.I have lastmodifiedtimestamp column, parent_id to join table-A and Table-B.Please let me know the best way to update the table.thanks in advance. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-05-01 : 13:06:36
|
| Can you post some sample data so we can get a better understanding of how your data is..?Dinakar NethiSQL Server MVP************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Table update status