I mean I didn't use With...

SELECT *, group_id=ColA-ROW_NUMBER() OVER (PARTITION BY ColB,ColC,ColD ORDER BY ColA)
INTO #Temp2
FROM #Temp

SELECT *, rn=ROW_NUMBER() OVER (PARTITION BY ColB,ColC,ColD,group_id ORDER BY ColA)