Please take a look at this and see what you think

DROP TABLE IF EXISTS #LastTimeTankDrained;

CREATE TABLE #LastTimeTankDrained
(
    Tank CHAR(2)
   ,LastDrain INT
 ...

What the data represents is confusing me a little, can you expand on it a little, please?

Take TankDate 1/1/2021 as an example. There are 6 rows, with DrainSeq ranging from...

Recovering the missing day's data might not be as difficult as you think. People here will help you.

Approximately how many tables in the database, in total, are likely to contain...

I don't think I'll be telling you anything that you don't already know ...

If the 'missing' data exists only on the crashed server, you have to wait until the crashed...

Glad to help. I learned a few things along the way too.

If you have more questions, please post back ... it was a good challenge.

Please try this to get you started:

DROP TABLE IF EXISTS #SomeJSON;

CREATE TABLE #SomeJSON
(
    J NVARCHAR(MAX) NOT NULL
);

INSERT #SomeJSON
(
    J
)
VALUES
(N'{
  "name":...

For now, forget about the Excel bit. There are several ways of getting your query results out, once the query has been written.

If I, or someone else, show you how...

Ratpak

 Do you want the data flattened (in which case you'll get lots of duplicates at higher levels)?  Do you want to return multiple results sets of more normalized...

Yes, notifications seem to be working again.

I recommend that you use the visualiser to decide on which columns to include in one or more row/column datasets you wish to extract and take it from there.

JSON's infinite flexibility is also its downfall in cases like this. There is no SELECT * with JSON data, because the data can be very hierarchical.

If you paste the JSON...

It's not clear exactly what you are trying to achieve, but this is a start, showing how you handle JSON in T-SQL. If your desire is for something more complex,...

You have provided an error message, but not asked any questions.

I am no longer receiving e-mail notifications when someone responds to a post I am subscribed to. Is it me, or is this affecting others?

The fact that you wish to use an OLEDBCommand suggests that you wish to put this in a data flow, is that correct?

I presume that you realise the impact of...