> >INSERT INTO AlertImport > (Active, > ExpiredDate, > ContractNo, > SystemId, > ItemNumber, > Description, > Price, > ContractSeverityCode, > EquipmentSerialNumber, > LineType, > AddressCode) > SELECT Active, > ExpiredDate, > ContractNo, > SystemId, > ItemNumber, > Description, > Price, > ContractSeverityCode, > EquipmentSerialNumber, > LineType, > AddressCode > FROM AlertImport >If identity is the first field, you don't have to specify all fields.