What is the end goal here? You could, for example, easily use a Foreach Loop Container to go through the folders recursive and filter to zip files. Why does it...

Considering that Office 365  didn't exist in 2012, then it might not be able to, if I am honest. If you know support is on SQL Server 2016+, however, and...

it would be 7

But why would it be 7? You haven't explained the logic for 4_5 and 4_2 either.

The short answer is yes, you can do this in SSIS. It has a range of connection managers, and you would be able to connect to MySQL and SQL Server...

What about the rows which have a value of 'Prod10000'? How do you determine what value of Prodstatusid is returned; is that the MIN too? What is the logic for...

SSAS for Visual Studio 2022 is also now available. So SSIS is the only one that is missing.

You've been around enough to know by know that images of data don't help us help you, and that DDL and DML is much better for making it easier for...

That is what you are doing; the LTRIM would be processed first, then the RTRIM, and finally LEFT. Perhaps you mean...

With that said, how do you choose to leave "notes" in an .rdl?

You don't. This is exactly what Version Control is for; so you can note what you have changed....

Also, an nvarchar(max) is the wrong choice of data type. HASHBYTES returns a varbinary with a length of up to 8000.

If you are trying to, perhaps compare the hashed value to the user input, what you should be doing is rehashing the value (in the application) and then comparing it...

Yeah....I agree.  I didn't think we could get the resource issue fixed for running the CTE solution.  It's in Starburst, not SQL Server.  But, thank you.  This would be...

What DDL? What about the DML? You havem't given any. DDL is...

Are you able to provide us with some sample data for your expected results in DDL and DML statements? That'll help us help you.

Unfortunately very true. Considering VS 2022 actually came out in 2021, I wouldn't put it past them...