Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I compare two datasets to see if one of them changed?
TableB is essentially an archive table (it exists in a different DB on the same server). Since TableA allows DELETEs, if I truncate TableB and then just copy from TableA, I'll lose records from TableB. The rule is, keep in TableB the latest version of every row that has existed in TableA. -
How do I compare two datasets to see if one of them changed?
I have two tables, TableA and TableB. TableB holds a copy of some records in TableA. TableB is read only. TableA is live--rows are added, deleted, and updated regularly. I need to write a script to see if rows from TableA which correspond to rows that exist in TableB (by corresponding ID...
