t-sql 2012 change logic to not be a cte

Thank you for your answer so far! Can you should me another way to just use the sql I listed above to use only 1 update statement if that is possible?