In SQL Server, there is a way to assign a usable column alias, using CROSS APPLY:

SELECT TOP (1000) ST100
FROM CONSUL AS CD
LEFT JOIN table2 AS [Sx] ON...

Double any existing single quotes in the data:

... + REPLACE(data, '''', '''''') /*make every ' in the data become '' */ + ...

I've never seen an UPDATE pattern that bizarre in over 30 years in IT.  From 6 to 16,000,000?  I can't even imagine the business case that would cause...

"Standard Procedure...

I still prefer my single int as a metakey method.  16 bytes is a lot of overhead for a linking key.  I don't see an advantage to it. ...

I still prefer my single int as a metakey method.  16 bytes is a lot of overhead for a linking key.  I don't see an advantage to it.  And the...

Like I said in the comments in the code...

     -- You...

And what if one or more of the column values change?

Only someone with full sysadmin authority can change a job's owner.

Typically after the job is fully debugged and running normally, sysadmin changes the job owner to a standard job-running account.

If...

I added an RTRIM to get rid of any trailing space(s).  Naturally if you don't want to do that, delete the RTRIM from the code.

SELECT 
 ...

SELECT
    string_to_parse,
    CASE WHEN first_dash = 0 THEN ''
         WHEN first_dash = last_dash...

This looks to me like a Gaps and Islands query.  Itzik Ben-Gan has posted numerous articles and written in books how best to solve those types of queries.

You have some values that have leading zeros.  Must the leading zeros be preserved?  If so, then not all of the columns are actually INTs as you...

nvm, OP obviously not interested at all in this approach.

I was too enthousiastic. What I did was I only took the 7 character long records (WHERE LEN(column1)=7) and then applied the LEFT functions as indicatde above. But,...