So, thanks to Michael L John and TheSQLGuru for actual helpful pertinent information that followed my question.

I have followed your pattern somewhat and gone with CTEs to gather the 'base'...