I am trying to sort out this issue where I need the last row to be inserted at the right location distance wise. This is a query from 2 tables: Observation and Inspection. Observation table contains the foreign key of the Inspection table. This query only contains the observations of inspection with Key 104. Sometimes in the inspection process of a pipe, the operator miss observations and I would like to add them and place them in the right order ( distance wise). I know the last record is repeated. I am just using it as an example. So the last record would be placed after record with observationID 915.
Thank you in advance,