Hello, I have a table that has the rows:
AccountID OtherReInfo CreatedDate ModifiedDate
It's created by an insert statement. It has records on it, based on the AccountID.
What i want to know is how do to this:
Insert each new record from an insert into statement, but check:
1. if the record does not exist, and if it doesn't insert it and update the createdDate with getDate
2. if the record does exist, check the otherReInfo column, and see if it's different, and if it is, then update that row, and also the last modified date to getDate()
3. if the record is the same, then do nothing, and move to the next row,