first question is why username/password (unsecure) and not windows authentication.

Second - unless you add the users to the database no one will have access to those db's - so that...

you don't state what is the application running on the VM that is trying to connect to the server - but assuming it uses standard connection strings and that you...

you are as suspected running on a VM machine - while your config may be ok for your workload you should monitor your usage to see if you need more...

as I've shown you on the other thread you have a construct that calculates the values you need.

you then use those calculated values on the main query.

pseudo...

use the same outer/cross apply construct you were given on your other thread

that is one of the good cases for it - define the values to use on the apply...

even if you don't have the buttons you can use the tags as I mentioned.

using cross/outer apply means that you can then use the new columns elsewhere as I did - making the code cleaner.

so on your own example with your concat ",CONCAT(DD, '-',...

you were clear - but you did NOT show us the code where you are trying to concatenate the fields - without that we can't tell you what you did...

you didn't really post your code here neither the error you got - but look at function datefromparts which will allow you to do that easily.

for info - kind of only found out recently why I still have the debug menu available.

I use SQL Complete PRO from Devart - this product adds the debug option...

can you give us the output of these queries

select @@version

select cpu_count
     , hyperthread_ratio
     , physical_memory_kb
    ...

on your command line you are using to create the .7z files you just add the extra parameter to 7z

MAX DOP should also be changed as well as CTFP value as they likely on default (0 and 5 respectively)

DOP depends on how many CPU's you have - CTFP I...

SQL Server Agent job account needs access to the share/file - that is where it is failing now.

Or the Proxy account used to run SSIS packages if you defined one...

its documented even if not clear for some.

https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16

| derived_table [ [ AS ] table_alias ] [ ( column_alias [ ,...n ] ) ]