insert pubs.dbo.test
select(LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,Postalcode,Country,Homephone,Extension,Photo,Notes,Reportsto,Photopath) select(LastName,FirstNa
select(LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,Postalcode,Country,Homephone,Extension,Photo,Notes,Reportsto,Photopath) select(LastName,FirstNa