Help with a trigger or computed column
Posted on 2013-10-22
I had already asked this, and then closed the case. However, I realize the answer I accepted did not work. So.....
I have a table with an end date column and a long value that is a status. I want to set the status to a specific value whenever the current date is great than the end date.
A computed column will not work, unless I do not understand something. A computed column is just that - always computed. What I need to do is automatically update a non-computed status column based on the fact that the current date is greater than the EndDate column. My non-computed status column is also updated via code based on other factors.