I was looking for some simple logic of a trigger to update values of a cloumn to something based on a entry value of a row in the same column. Example: When someone sets the status column to to active for one record, rest of the values should automatically get updated with inactive status. There can be only one record with active status, and everything should become inactive when you make any one record active.
The biggest problem is mutating errors..
day, status
SUN,Inactive
MON,Active
TUE,Inactive
WED,Active
THUActive