A Follow up question or the Order by. Running the command gives me the results. There are some that are a negative number and tried ordering it both Asc and...

Hi Jeff,

First thank you for responding,

The first column is the name of the locations. some are represented as a decimal  representing the mile post of a location, however it is...

Here is what I have tried. However there is no change in the failures listed in the sample so the change column should be a zero not a one. I...

This was very helpful. I learned some also from it.

I hopefully have posted my current question in a better format and have explained myself well enough.

Thank you

Thank you. Good suggestion.

Thanks, that worked in the corrected script I posted.

So, change it to this?

SELECT *
INTO Codelines_Backup
FROM Codelines;

DELETE FROM Codelines;

DBCC CHECKIDENT ('Codelines', RESEED, 0)
GO

INSERT INTO Codelines (Rail_Road, NCS_Codeline, NCS_Subdivision)
SELECT Rail_Road, NCS_Codeline, NCS_Subdivision
FROM Codelines_backup
ORDER BY ID ASC;

Thanks,

Jeff,

You are correct in what you say below here. the leading 6 is dropped from the final product as it identifies that as a base. So the resulting values of...

Correct.

Is the base value always formatted as {region}.{port}.{poll} - with region = 4 digits, port = 1 digit and poll = 2 digits?

Yes, the first digit of the Region is...

Here is the ATCS_Group Table;

USE [nms_cfg4]
GO

/****** Object:  Table [dbo].[ATCS_Group]    Script Date: 06/11/2021 12:23:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ATCS_Group](
[Group_Address] [float] NOT NULL,
[Subregion]...

the fourth and sixth digit is a decimal symbol ".", would that affect this?

Jeffrey, here is a sample of the be_xref.oa table;

base_equip_addressoffice_app_addressx_pbaseregionportpollxprimarypath_typedesignator
22009121220169126912111691201110NULL
2201003120016003600310160030110NULL
2201108222016108610820161081110NULL
2201108322016108610830161082110NULL
2201169122016169616910161690110NULL
2201172222016172617220161721110NULL
2201173222016173617320161731110NULL

Here is a sample of the atcs_group table;

Group_AddressSubregionLine_Addressleft_neighbor_groupright_neighbor_groupATCS_GroupNameStateDescriptionMilepostLongitudeLatitude
220030010000NULL220030000000NULLNULL1Hauser B House West MainIDNULLNULLNULLNULL
220030020000NULL220030000000NULLNULL2Hauser B House West BlueIDNULLNULLNULLNULL
220030030000NULL220030000000NULLNULL3Downing...

Jeff Moden, yes, I am the original author. I had another SQL database person working on it late last year before moving to SQL 2019. This is the only code...

Ok! I figured it out. Somewhere along the way the Master database tag was added into a portion of the Stored Procedure;

SELECT    [Name] +...