C:\Documents and Settings\Administrator>bcp "select firstname, lastname, addressline1, city, p.stateprovincecode,postalcode, phone from adventureworks.sales.vIndividualCustomer s join adventureworks.person.stateprovince p on p.name = s.stateprovincename where p.stateprovincecode in ('IL','IN','MO','CA')" queryout advcust.txt -T -c
bulk insert vwcustomerNOID
from 'C:\Documents and Settings\Administrator\advcust.txt'