@SQLRunr That's my thoughts but worried about performance, thinking filtered indexes might help me with that
1
0
0
0
0
@SQLdba_Darryl Triggers perform well if you keep what they do to a minimum. Updating 1 row in the table before an insert shd not be a prblm.