Skip to content
English
Go to surgere.com
  • There are no suggestions because the search field is empty.

Script to remove Lane Assignments

This is the script to close out lane assignments that are left open and either need mass updated or can no longer be closed via Interius.

Script to remove LA:

ECLARE @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=15472,

Update_dt=@clear_dt,

Status=1

WHERE lane_assignment_id in (3180702)

Add Below if Honda

UPDATE DynamicDemandPickList

SET Status=3,

UpdatedId=15472,

UpdatedDate=@clear_dt,

CreatedId = 15472

WHERE LaneAssignmentId in (3180702)