#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
@SQLdba_Darryl I'd start at the process. Sounds almost like a "Slowly Changing Dimension" concept #sqlhelp