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,...

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 said.  Let...

Actually, for this one, I just looked at the query plans.  The other code is doing...

• This reply was modified 5 years, 1 months ago by ScottPletcher.

This has less overhead, which may or not be a concern to you for this task, but I thought I'd post it just in case.

;WITH cte_find_last_2_dashes AS...

CREATE TABLE #3NF_ATCCOLLECTION 
    (
    ATC_KEY varchar(7) NOT NULL
    );
INSERT INTO #3NF_ATCCOLLECTION VALUES
    ('A10'), ('A10Q'),...

To answer the question, you could instead change the criteria you cited to...

AND log_reuse_wait_desc <> Nothing'

Like I said in the comment in the code I posted,...

we are currently doing a 1 hour tran log backup for a system, I'd like to push that up to 1 minute. Is there a performance hit to...