Ron K's first solution is elegant and simple.

I would make one small change in the Order By clause. 

Select min(ID) as ID, PathwayID

From #MyTable

Group By PathwayId

Order By PathwayID, ID

The original question...

To answer part of your question: When you have the first Temporal table imported, the code below will add new records to the existing table and add the records that...