Script to clear old lane assignment

DECLARE @clear_dt datetime = CONVERT(DATETIME, Switchoffset(Getdate(), Datepart(tzoffset, Getdate() at time zone 'Eastern Standard Time')))

UPDATE lane_assignment

SET Clear_dt=@clear_dt,

Update_ID=<Created ID>,

Update_dt=@clear_dt,

Status=1

WHERE lane_assignment_id in (<Lane Assignment ID>)

UPDATE DynamicDemandPickList

SET Status=3,

UpdatedId=<Lane Assignment ID>,

UpdatedDate=@clear_dt,

CreatedId = <Created ID>

WHERE LaneAssignmentId in (<Lane Assignment ID>)