Flyt strækning i Cracking:

update Cracking 
set 
Cracking.[From Reference Point] = Cracking.[From Reference Point] +/- JUSTERING I KM,
Cracking.[To Reference Point] = Cracking.[To Reference Point] +/- JUSTERING I KM
where 
Cracking.[Road number] = 'VEJNUMMER'

Eks. Strækningen flyttes 10m frem:
update Cracking 
set 
Cracking.[From Reference Point] = Cracking.[From Reference Point] + 0.01,
Cracking.[To Reference Point] = Cracking.[To Reference Point] + 0.01
where 
Cracking.[Road number] = '0500304'



Flyt strækning i Guard Rails:

update "Guard Rails" 
set 
"Guard Rails".[FromReferencePoint] = "Guard Rails".[FromReferencePoint] +/- JUSTERING I KM,
"Guard Rails".[ToReferencePoint] = "Guard Rails".[ToReferencePoint] +/- JUSTERING I KM
where 
"Guard Rails".[Roadnumber] = 'VEJNUMMER'


Flyt strækning i Light Poles:

update "Light Poles" 
set 
"Light Poles".[ReferencePoint] = "Light Poles".[ReferencePoint] +/- JUSTERING I KM
where 
"Light Poles".[Roadnumber] = 'VEJNUMMER'


Flyt strækning i Potholes:

update Potholes 
set 
Potholes.[Reference Point] = Potholes.[Reference Point] +/- JUSTERING I KM
where 
Potholes.[Road number] = 'VEJNUMMER'


Flyt strækning i Reference Poles:

update "Reference Poles" 
set 
"Reference Poles".[ReferencePoint] = "Reference Poles".[ReferencePoint] +/- JUSTERING I KM
where 
"Reference Poles".[Roadnumber] = 'VEJNUMMER'


Flyt strækning i Sensor:

update Sensor 
set 
Sensor.[From Reference Point] = Sensor.[From Reference Point] +/- JUSTERING I KM,
Sensor.[To Reference Point] = Sensor.[To Reference Point] +/- JUSTERING I KM
where 
Sensor.[Road number] = 'VEJNUMMER'


Flyt strækning i Signs:

update Signs 
set 
Signs.[ReferencePoint] = Signs.[ReferencePoint] +/- JUSTERING I KM
where 
Signs.[Roadnumber] = 'VEJNUMMER'


Flyt strækning i Traffic Lights:

update "Traffic Lights" 
set 
"Traffic Lights".[ReferencePoint] = "Traffic Lights".[ReferencePoint] +/- JUSTERING I KM
where 
"Traffic Lights".[Roadnumber] = 'VEJNUMMER'