Apparently, I left the code window open from when Jeff deleted the thread and I couldn't post anymore. It changes how you create the the ranges, so I'll post it...

You should pivot your values in SSRS. That will be more efficient.
Here's how you do it: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/create-a-matrix-report-builder-and-ssrs

Why are you using CompanyName in your column list and dataname to relate between the tables?

Here's an example on how to remove the loop and query in an...

Without even changing the parameter type.

CREATE TABLE #SampleDates(
  SomeDate smalldatetime
)
CREATE CLUSTERED INDEX CISampleDates ON #SampleDates(SomeDate)

INSERT INTO #SampleDates
SELECT DATEADD( hh, (ABS(...

Depending on the length and available storage, this could be an option.
https://sqlperformance.com/2017/02/sql-indexes/seek-leading-wildcard-sql-server

Somehow, the explanations defending the sum of an empty set as null don't make as much sense as the arithmetic explanation from Tom.
SUM is essentially a mathematical function, the...