What is the actual SQL you're running here?

What have you tried so far? Have you had a look at PIVOT, or (what many prefer), using a Cross Tab?

Cross post of https://www.sqlservercentral.com/forums/topic/how-to-map-the-table-data-while-inserting-into-another-table-in-sql and https://www.sqlservercentral.com/forums/topic/how-to-map-the-table-data-while-inserting-into-another-table-in-sql-2. I suggest replying on the OP's original post.

Cross post of https://www.sqlservercentral.com/forums/topic/how-to-map-the-table-data-while-inserting-into-another-table-in-sql and https://www.sqlservercentral.com/forums/topic/how-to-map-the-table-data-while-inserting-into-another-table-in-sql-3. I suggest posting on the OP's original post.

OK, personally, I would return a dataset like this then (I've guessed you want split by tier, if not add a WHERE ):

SELECT c.[name],
   ...

I assume that that unnamed column in the CREATE statement for #storage should be called size?

I very briefly read that script (as Drew said, the longer the script the less likely people are to look at it), but if you are trying to create a...

I don't think it works like this. Parameter is what you put on the WHERE clause. If  you want change table name, concatenate:

SELECT @SQLString = N'Select...

Have you inspected the logs of the SSIS package? Is anyone else using the instance and thus could there be a lock on the table(s) the SP is being queried...

Ignoring the fact that the dates are a week apart 😉 I did a search before replying and that told me that Colorado is also on daylight savings time...

Yep, that got me to the answer I needed, Drew. My final query using production data is quite different, but the nested SUM with the OVER is exactly the route...

Thanks Drew. I think that's what I'm after. The data above was pre-aggregated, so i'll give a go at applying this to the non-preaggregated but I think this is very...

In what sense? Are you restoring over an existing database, or creating a new one. If the latter, there is no downtime, as such. If an existing one, I assume...

I agree that seeing extra resources in Express would actually be nice. According to Compare SQL Server 2017 Editions Express can have 1410MB of RAM, but that's still not...

You say mostly 2008 servers, any older than 2008?