This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data and...

If you rounded the numbers, it seems like you'd end up with 296, 4, 1:

SELECT 300*.986, 300*.012, 300*.002 --295.800, 3.600, 0.600

The first round up seems clearest, so 296.  You'd have...

This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data and THAT's what...

The patient's name is not present anywhere.  That is, there's no way to know who patient "A", let alone to know what doctor(s) he/she saw.

This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data and THAT's what actually needs...

This was an interesting problem because for 'Shift' rows, you need to output only one row.  But for non-'Shift' rows, you (mostly) need to output two rows: a row for...

I wouldn't go thru all those gyrations to pull out the values.  Imagine the hassle to just add one more column to the output.

I'd do something similar to this instead.

I think this will work.  I have NOT yet adjusted it for performance (or tuned it at all yet, really), I was just trying to make it work.  Let me...

As noted, a LEFT JOIN is what you need.  An INNER JOIN requires a matching row in both tables; a LEFT JOIN will keep the row from the left-hand table...

You must use the alias to insure accurate UPDATEing.  You can, and quite often will, get inaccurate results when using the full table name instead.  (The error may now only...

I agree, sounds very much like class work.

Actually you're pulling more than 52 weeks' worth that way, but here goes.  Note that since you provided no sample data to test it with, you'll need to do the...

Excellent idea.  That gets much closer to the given size.

There's one very minor miscalc above, in that I believe page data can never exceed an absolute max of 8060 bytes,...

SELECT title, 
    SUBSTRING(title, CHARINDEX('E00', title), 200),
    Computed  = CASE WHEN CHARINDEX('E00', title) = 0 THEN NULL
   ...

Would you script out the table to make sure no other column "snuck" in there?

And please verify the row count:

SELECT SUM(rows) AS row_count
FROM sys.partitions
WHERE object_id = OBJECT_ID('dbo.SIData_222222_88_20211103_1436')...