#sqlhelp how to have only the most recent record marked with a bit? Bit must change to 0 as record ages.
2
0
0
0
0
@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