Did not realize there are more pages and similar queries have already been posted. Please ignore.

Here's one way of doing it based on the data you sent. Some things may change if my assumptions are not correct.

Also, I tried to use as many CTE as...

Why can't we just recompile the function everytime we execute a DML Statement on one of the tables in the Return List?