try this

INSERT

INTO [dbo].[Employees] (ID, [Name])

SELECT

  --ID

  [ID],...