INSERT into dbo.DimCustomer(CustomerId, CustFirstName, CustLastName,Country,City,PostCode,Telephone,
Occupation,Company)
SELECT
CustomerID,
ContactName = SUBSTRING(ContactName,1,CHARINDEX(' ', ContactName)),
ContactName = SUBSTRING(ContactName, CHARINDEX(' ', ContactName) + 1, LEN(ContactName)),
Country,
City,
PostalCode,
Phone,
ContactTitle,
CompanyName
FROM
NorthWind.dbo.Customers