Help with sql query insertion
Posted on 2009-07-15
I have a situation here, on a daily basis i need to import data from oracle 9i tables into our sql server 2005 table, but the primary phone from source has to be split into phone area, phone, phone extn in destination and also the primary name into firstname and last name by mentioning it during insertion, can you help me with that please? hope i am clear..
INSERT INTO SQL.TABLE
SELECT PRIMARY_NAME, PRIMARY_EMAIL,PRIMARY_ADDRESS1,PRIMARY_ADDRESS2,PRIMARY_CITY,PRIMARY_STATE,PRIMARY_ZIP,
PRIMARY_PHONE,PRIMARY_FAX FROM CUSTOMERS