I'd be interested to hear other points of view on this as well.
Some thoughts:
- Im not opposed to using an indexed view or computed column, it's often a good way to maintain extra data without the hassle of triggers.
- I agree with Jon that since all access is gated through the stored proc and given that the proc is documented, I don't see his approach as being dangerous or hard to maintain. After all, this table does represent a good sized chunk of what he is doing, not a minor piece that might be overlooked.
Andy