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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-09 : 00:51:31
|
| Jon writes "I am daily, passed a set of flat files, containing a complete output from a mainframe holding the master dataset.I have an import routine that reads these files into a relational SQL Server 7 database.The flat files do not contain any lastupdated type information but I need to identify what has changed.I thought I would have a second copy of the SQL database with insert/update triggers on each table which would populate some additional datetime fields.Identifying additional records is easy using WHERE NOT EXISTS etc etc, however, What about updates?Can you think of an easy, efficient way to compare two rows and identify any changes??Any help would be much appreciated.ThanksJon." |
|
|
|
|
|
Comparison of rows in different databases