• In this case, use Temp table.

    suppose you try to update CTE, It will update the source table value. it will lead data loss.