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 dencom 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?
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...
