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 - 2000-11-30 : 11:10:36
|
Anthony writes "Hi guys:
I am quiet new in SQL server database environment, i have a database that is refreshed monthly, month over month, records are added or deleted or changed. For, each monthly update, i have to figure out what records are added, records are deleted or changed from the new data this month to last month. Now, the database has phone fname,lname and address infos (address1, address1, city, province, postal). For, those records, that remained the same, that is phone, name and address
info remain the same, i want to leave them as it is. For, those records that is updated (changed): eg. i moved to a different area, i keep my phone number, the record is updated or i move to a new apt # in the same apt. my address is updated and phone # is still the same, deleted or updated, i want to identify those.
Any help will be greatly appreciated.
Thanks
I am currently using SQL 7.0 on a NT workstation." |
|
|
|
|
|
|
|
updating database monthly