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...

The issue with parsing is there are 6 different delimiters (including 'Supervisor') when you really only need 1.  With 1 delimiter an ordinal splitter (which is based on a tally...

It's the same idea with a clock as with a calendar

https://www.sqlservercentral.com/forums/topic/get-total-no-of-minutes-by-hour-hand-between-two-dates#post-3900058

It appears spacing within certain code blocks have been removed.  It appears to be retroactive across history too.

In my most recent response the spaces in the results code block appear...

"...is it possible to determine the number of years to be able to iterate them and in each turn set the new dates?"

To determine the number of years "to iterate"...

Maybe this

SELECT D.DocumentID AS [Document ID], D.Filename AS [Document Filename], 
       XR.XRefDocument As [Child Document ID], D2.Filename AS [Child Filename], 
...

Maybe it's better to nest PATINDEX functions instead of reversing the string(s)

declare
  @srch             varchar(100)='%[1-2][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9]%';

/*...

This can be a bit of a pita.  It helps greatly if there is one and only one acceptable date format, like YYYY-MM-DD (padded with zeros).  Another issue is what...

"How can I insert as zero amount if not exist in my working table?"

It seems maybe you're looking to LEFT JOIN the two tables together.   Obviously, you cannot assign attributes...

Maybe something like this.  I added some additional example rows.  It's similar to this other post imo.

insert #temp_docs(BegVal, EndVal, Volume, Prefix, Padding, begnum, endnum) values
('ABC000063738', 'ABC000063738',...