Been rooting for France as a committed Francophile my whole adult life.  

AAAaaaaalez les Bleues !!!

It's  all good I cracked  the joins, just had to repeat the joins twice as such...

WITH Base AS (
SELECT
  CSM.[First name]
 ,PP.[Fname]
 ,CSM.[Last name]...

Thanks bud, that code works stand-alone, now I'm trying to do a couple of joins to filter;

  Inner Join personalprofiles PP
  ON
  L.ProfileId  = PP.ID
 Inner...

Been recently doing something similar for my own client but without the 'Impact Mapping'.  

Seems, from your description, your customer needs to put on their 'ideas' hat, as...

I got it...

Begin tran
Update ranks
Set name =
replace(replace(name, ' /', '/'), '/ ', '/')
from ranks
Where name like '%...

As a result set, yes, but I want to actually commit the change.

That hit the spot, though I was surprised that: 

A) You concocted that advanced code in what...15 mins flat??!?!?
B) The code affected 86,808 rows of data, which was...