This took a bit of head scratching.  I managed to solve it, assuming that there are a max of 3 parts per group (as per your example).

I then added a...

Create some sample data

DECLARE @SAMPLE_SIZE BIGINT = 1000;

DECLARE
      @MinInt       int = 10000
    ,...

This article from Brent Ozar might help

https://www.brentozar.com/archive/2018/09/sql-server-2019-faster-table-variables-and-new-parameter-sniffing-issues/

Duplicate post removed

A TVP is a table variable.  Variables do not have any statistics.  Historically SQL always assumed that a table variable contained exactly 1 record.  In SQL 2019, this was changed...

To create sample data for people to assist you with ...

CREATE TABLE #TsetData (RBDCTL int, RBDTTC int, RBDTYR  int);

INSERT INTO #TsetData ( RBDCTL, RBDTTC, RBDTYR )
VALUES...

OK, try it as a basic aggregate

SELECT    RBDCTL
        , RBDTTC
       ...

Try using a window function

SELECT    RBDCTL
        , RBDTTC
        , MaxYear...

Since you have not provided an expected output, hopefully this will get you started

DECLARE @RefTable table (
    ID      ...

This is a great book on indexing

Expert Performance Indexing in SQL Server, Second Edition

I use the following script to search for dependencies

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

DECLARE 
    @ObjectSchema SYSNAME = '' /* You can limit the...

It...

CharIndex only uses a single character. For a...

Something like this

CREATE TABLE #MyTable (ID int, DATA NVARCHAR(MAX))

INSERT INTO #MyTable values (1, 'ID:12345, Name: Chris , Tiger, Sal:3000, City: NYC')
      ...

CharIndex only uses a single character.

For a group of characters,...