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'