Hi, easy solution: delete all records from table 2 and then insert all records from table 1.
Chris > -----Urspr�ngliche Nachricht----- > Von: Sam Jia [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 16. Oktober 2001 19:35 > An: JRun-Talk > Betreff: 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
