Flyt strækning i 5190327:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 3.245, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 3.245 where Cracking.[Road number] = '5190327'

update "Guard Rails" set "Guard Rails".[FromReferencePoint] = "Guard Rails".[FromReferencePoint] + 3.245,"Guard Rails".[ToReferencePoint] = "Guard Rails".[ToReferencePoint] + 3.245 where "Guard Rails".[Roadnumber] = '5190327'

update "Light Poles" set "Light Poles".[ReferencePoint] = "Light Poles".[ReferencePoint] + 3.245 where "Light Poles".[Roadnumber] = '5190327'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 3.245 where Potholes.[Road number] = '5190327'

update "Reference Poles" set "Reference Poles".[ReferencePoint] = "Reference Poles".[ReferencePoint] + 3.245 where "Reference Poles".[Roadnumber] = '5190327'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 3.245,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 3.245 where Sensor.[Road number] = '5190327'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 3.245 where Signs.[Roadnumber] = '5190327'

update "Traffic Lights" set "Traffic Lights".[ReferencePoint] = "Traffic Lights".[ReferencePoint] + 3.245 where "Traffic Lights".[Roadnumber] = '5190327'





Rettelse 5190327:
update Cracking set Cracking.[Road number] = '0500556' where Cracking.[Road number] = '5190327'

update "Guard Rails"  set  "Guard Rails".[Roadnumber] = '0500556' where  "Guard Rails".[Roadnumber] = '5190327'

update "Light Poles" set "Light Poles".[Roadnumber] = '0500556' where "Light Poles".[Roadnumber] = '5190327'

update Potholes set Potholes.[Road number] = '0500556'where Potholes.[Road number] = '5190327'

update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500556'where "Reference Poles".[Roadnumber] = '5190327'

update Sensor set Sensor.[Road number] = '0500556'where Sensor.[Road number] = '5190327'

update Signs set Signs.[Roadnumber] = '0500556'where Signs.[Roadnumber] = '5190327'

update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500556'where "Traffic Lights".[Roadnumber] = '5190327'



Flyt strækning i 5391708: Den ene vej 0500317

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 9.540, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 9.540 where Cracking.[Road number] = '5391708'

update "Guard Rails" set "Guard Rails".[FromReferencePoint] = "Guard Rails".[FromReferencePoint] + 9.540,"Guard Rails".[ToReferencePoint] = "Guard Rails".[ToReferencePoint] + 9.540 where "Guard Rails".[Roadnumber] = '5391708'

update "Light Poles" set "Light Poles".[ReferencePoint] = "Light Poles".[ReferencePoint] + 9.540 where "Light Poles".[Roadnumber] = '5391708'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 9.540 where Potholes.[Road number] = '5391708'

update "Reference Poles" set "Reference Poles".[ReferencePoint] = "Reference Poles".[ReferencePoint] + 9.540 where "Reference Poles".[Roadnumber] = '5391708'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 9.540,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 9.540 where Sensor.[Road number] = '5391708'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 9.540 where Signs.[Roadnumber] = '5391708'

update "Traffic Lights" set "Traffic Lights".[ReferencePoint] = "Traffic Lights".[ReferencePoint] + 9.540 where "Traffic Lights".[Roadnumber] = '5391708'



Flyt strækning i 5391708: Den anden vej 0500520

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 14.045, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 14.045 where Cracking.[Road number] = '5391708'

update "Guard Rails" set "Guard Rails".[FromReferencePoint] = "Guard Rails".[FromReferencePoint] + 14.045,"Guard Rails".[ToReferencePoint] = "Guard Rails".[ToReferencePoint] + 14.045 where "Guard Rails".[Roadnumber] = '5391708'

update "Light Poles" set "Light Poles".[ReferencePoint] = "Light Poles".[ReferencePoint] + 14.045 where "Light Poles".[Roadnumber] = '5391708'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 14.045 where Potholes.[Road number] = '5391708'

update "Reference Poles" set "Reference Poles".[ReferencePoint] = "Reference Poles".[ReferencePoint] + 14.045 where "Reference Poles".[Roadnumber] = '5391708'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 14.045,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 14.045 where Sensor.[Road number] = '5391708'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 14.045 where Signs.[Roadnumber] = '5391708'

update "Traffic Lights" set "Traffic Lights".[ReferencePoint] = "Traffic Lights".[ReferencePoint] + 14.045 where "Traffic Lights".[Roadnumber] = '5391708'