Though no one suggested it, there are indeed tools that can help with this. One would be Red-gate SQL Data Compare. See www.red-gate.com.
/charlie -----Original Message----- From: Sam Jia [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 1:35 PM To: JRun-Talk 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
