Set up some data (you should have done this when asking the question)

DROP TABLE IF EXISTS #temp
GO
SELECT *
  INTO #temp
  FROM (VALUES (1, 'ON_001', '12/5/2022'),
...

Here is my attempt:

That worked and is reasonably efficient.

You can just schedule the job to run every 5 minutes starting at 7 am until a time when you say the file has failed to arrive.

Freakin' awesome test post, Jonathan.  Well done, good Sir!!!  This also proves something else... code written to do a specific task is highly likely to blow generic methods out...

I think you can beat any splitting function by splitting in code with no need for aggregation.

As there are only a maximum of 4 values you...

You could consider using DBCC CHECKDB with the "PHYSICAL_ONLY" option, which only performs a physical consistency check and not a logical consistency check. This can significantly reduce the memory requirements...

I think you can beat any splitting function by splitting in code with no need for aggregation.

As there are only a maximum of 4 values you can safely...

Yes... and they're making an big deal about it.  ChatGPT is constantly providing incorrect answers about code...

I think you can beat any splitting function by splitting in code with no need for aggregation.

As there are only a maximum of 4 values you can safely use this...

You could try using sqlcmd instead of SSMS

Have you tried using both the -m and -f flags?

sqlserver.exe -m -f

You could try this:

Let me know if it works.

What I find extremely frustrating is when someone writes SQL code that joins multiple tables without prefixing the column names with their originating table or alias using dot notation. This...

I would not prefix a view with tbl.  In any case I rarely use views in an OLTP environment.  I do make extensive use of them...

I would not prefix a view with tbl.  In any case I rarely use views in an OLTP environment.  I do make extensive use of them in my...