SQL INSERT INTO SELECT

Copy all customers from Paris into the Supplier table.

INSERT INTO Supplier (CompanyName, ContactName, City, Country, Phone)
SELECT FirstName + ' Company', FirstName + ' ' + LastName, City, Country, Phone
  FROM Customer
 WHERE City = 'Paris'

INSERT INTO SELECT syntax.

INSERT INTO table-name (column-names)
SELECT column-names 
  FROM table-name
 WHERE condition

INSERT INTO Customer (FirstName, LastName, City, Country, Phone)
SELECT LEFT(ContactName, CHARINDEX(' ',ContactName) - 1) AS FirstName, 
       SUBSTRING(ContactName, CHARINDEX(' ',ContactName) + 1, 100) AS LastName, 
       City, Country, Phone
  FROM Supplier
 WHERE Country = 'Canada'

Note: LEFT, CHARINDEX, and SUBSTRING are built-in functions.

• Our Sql INSERT Reference
• Our Sql SELECT INTO Reference
• Our Sql Subquery Reference