Make sure you have a date field in there that tracks whenever a field was altered (updated, inserted, deleted etc.) and use this field to match up which records were changed.
If you want to match a particular changed field them just use SQL "LIKE" keyword and go from there. Matt ----- Original Message ----- From: "Sam Jia" <[EMAIL PROTECTED]> To: "JRun-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 16, 2001 10:35 AM Subject: find different data between 2 tables > Hi there > > question is: > I have 2 tables in MS SQL server 2000 with same structure. the data of 1st > table may changed by insert, update, and delete query. for each fixed > period, i want all these changes(new difference) of the 1st table during > that period applied to the 2nd table. is there any build in command for this > purpose? or there are other solutions. > > thanks > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
