You appear to be asking us to do your assignment for you, am I right? That table structure does not exist in the real world

My thoughts are that any password columns should be encrypted. No need to worry about DENY permissions if you do that.

This is not an easy format to achieve what you want, because the array items are not linked to each other.

But if you were to add a key to the...

I get that. Just substitute your...

Added local variables to make the code work in isolation. Your best bet is to output as a string:

DECLARE @J1 INT = 1;
DECLARE @JDate DATETIME = GETDATE...

• This reply was modified 1 years, 11 months ago by Phil Parkin.

Do you have any other local drives with available space?

Does the schema of the Access DB also change much?

If not, it would be better, in my opinion, to build a process to refresh the data in your SQL Server...

Please explain why.

Good job providing the table DDL and desired results. All you need to do now is give us the associated INSERT statements which generate the test data to populate the...

I'm framing this! 🙂

OK, that is good news.

In VS, take the following option:

Tools/SQL Server/New Schema Comparison

This will allow you to select your source database (local) and target (Docker version) and will then compare...

Forgive my lack of Docker knowledge – I've never used it. How do you connect to your database from outside of Docker? Can you connect to it from VS?

But the question is the same!

Perfect, thank you. That...

This seems to be the same question as https://www.sqlservercentral.com/forums/topic/t-sql-slicing-status-by-related-time-periods-and-other-status

Why did you create it again?