@SQLdba_Darryl I'd put an insert trigger on the table, setting existing row to 0 where it's set to 1, then set new row to 1. #sqlhelp

@SQLRunr That's my thoughts but worried about performance, thinking filtered indexes might help me with that

@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.