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