On second thought, instead of individually calculating the decimal costs they could be added all together into one value 'dCost'.  Also, a combination of TRY_CAST and ISNULL could be used...

The obligatory comment is regarding the problems arising from storing numeric data as varchar instead of decimal(#, #).  Assuming you're stuck with the DDL you could try something like this. ...

It appears you're looking for $137,000 less the running total of yearly license costs.  Also, the 'money' data type is imprecise and has serious issues so this uses decimal(14, 2)...

Simplified using OUTER APPLY instead of the LEFT JOIN

with
max_min_cte(t_min_dt, t_max_dt) as (
    select min(dateadd(hour, datediff(hour, 0, start_dt), 0)),
      ...

This uses a tally function (or it could be called a "numbers function") twice.  Once, to generate the total hourly datetime range across all rows in table #t.  Second, to...

select *, dateadd(hour, datediff(hour, 0, in_datetime), 0) out_datetime
from #data;

[EDIT] Same answer as Ant-Green but 2 minutes later 🙂

select left(isnull(stuff(first_name, 11, 3, '...'), first_name), 13) 
from @t1;

Another alternative could be CROSS APPLY

update t
set AmountAll = ca.sum_amount
from #test t
     cross apply (select sum(tt.Amount)
       ...

As long as people are sharing their CSV secrets.  Warning disclosure this contains C# code.  A couple of years ago I worked on a project for a fitness tracking system...

To start with maybe the OP could use a rental periods...

Another alternative using kaj's set up data

with cc_cte(cc1, cc2) as (
    select iif(row_number() over (order by Timestamp desc)=1, CallCount, 0) cc1,
   ...

The tone of this response has changed significantly since the notification email I got, with its contents. I was going to remind you that sites like this have "points"...

Welp, it seems worthwhile mentioning reputation points in an online forum, i.e. Stack Overflow, are a good way to enhance your resume.

But before we even think of getting started on this, let's NOT do it here.  Let's open a separate thread and have the OP provide some reasonable sample data...

There are some caveats which should've been mentioned.  The string is declared as NVARCHAR(MAX) because I don't know that that's not appropriate.  The ordinal splitter is name '%8K_LEAD' because it's...