IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind...

If you install this DateRange function, this gives certainly the shortest SQL if not the fastest

select CONVERT(date, d.value) Date, 
  ...

If you install this DateRange function, this gives certainly the shortest SQL if not the fastest

select CONVERT(date, d.value) Date, 
    ...

CREATE VIEW must be in a batch by itself, i.e., without GOs, you could create only one view per script.

Since GOs are likely not valid, that may be what...

We use Windows Task Sheduler and SQL Agent jobs.

Did you mean "Dijkstra"?

My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of testing needs to be...

Well you can test that too. I edited the original script I provided to do multiple inserts:

            
January 20, 2024 at 4:26 pm
            
#4364998

            
            
                                                
        

You could/should test it, here is an example of a test:

set statistics io, time off
set nocount on
go
drop table if exists #a;
create table #a(Id int, Date date, col1...

Exactly.  I summarize that as being "Confidently Incorrect" and, in that area,...

Not aimed at the author but aimed at the whole concept...  Let's look at the first example prompt in the article...

You are an SQL Server database developer. Assume...

You have some values in the varchar columns provPhoneMain or provPhoneFax that cannot be cast as bigint.

You could try using TRY_CAST which will return NULL if it cannot be converted:

You cannot directly edit files in an S3 bucket.

To edit them you would have to download the file edit it locally then upload the edited file to an S3 bucket.

Since you are using SQL Server 2019 you can use STRING_AGG

SELECT DISTINCT 
       pr2.col1,
       ISNULL(STRING_AGG(CASE...

SQL Server will use available memory to cache data. So if you allocate more memory to SQL Server it will probably use it. But that doesn't necessarily mean you need...