The proposed solutions seem to be a bit more code than is needed:

SELECT *
     , ActualID = substring(ss.Str1, patindex('%[1-9]%', ss.Str1), 25)
 ...

DROP TABLE IF EXISTS #SomeString;

CREATE TABLE #SomeString
(
    Str1 VARCHAR(25)
);

INSERT #SomeString
(
    Str1
)
VALUES
('D00241')
,('00242 ')
,('Chicken Tikka Masala');

SELECT ss.Str1
      ,CASE
...

Here is another version of your query which looks a bit tidier (as it does not rely on DISTINCT to remove dupes). But I'm not sure it will perform any...

You could try BISM Normalizer.

I haven't used it, but it looks promising.

You may be able to automate the production of a schema comparison report with it.

What do you want to happen in the case where the deployed version is found to be different from the VCS version?

Please provide your sample data in consumable format (in the form of CREATE TABLE/INSERT statements).

If the format of your desired output is exactly as stated, you would be better off...

Are there some people who think that 'duplicate' means 'same or similar'?

If it's a duplicate, it is exactly the same and can be dropped. Otherwise, it is not a duplicate...

Then either one of the responses given above...

Simply DROP the index you no longer wish to keep.

Are you working with Azure SQL databases (not managed instance)? Adding your user as DB_OWNER for each of the databases of interest should get you over the line.

All of my work is by remote desktop, and I find Windows does not manage multi-monitor RDP support very well. It frequently gets confused with windows placements, moving them...

Phil,

At this point everything is on the table!  Any info you can give on this would be appreciated.  We would be using ADF for this work as well.  It...

I suspect that encrypting the entire file after it has been created would be an easier process. Is that a possibility?

I'm curious about your setup for your...

You say that locking down security is not an option, but it should be.

Setting up a process such that your BIM only gets deployed from a VCS is the way...