SQL CTE Solution: Identifying Soft Deletes with Consecutive Row Changes

Update 'camp' Column with Last Value from 'camp2' Column Using MSSQL Lag Subquery for Offset

Using the `default` Argument in dplyr's Lag and Lead Functions