your inner query has a column (status) that is not on the group by - so you need to build your query differently

on this particular case and because you are...

and in addition to what Ant said make sure you have ALL of your replication setup scripted so you can re-apply it easily

better not to have them with passwords - any sensitive data for connection strings should be on config files (or config environments on SSIS catalog) - if on files they...

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