with T as ( select TemplateID,phaseID,orderNum,Row_number() over(partition by TemplateID,substring(phaseID,0,len(phaseID)-2) order by phaseID ) As orderNum2 from TemplatePhaseConfig )update T set orderNum=orderNum2
