title: .csv file import using sql bulkload or openrowset for missing column data
body: <p>.I have a <strong>csv</strong> file. The data is given below, </p>
  
  <pre>
  ___________________________________________________________
  StateName       |  City                 |  Score1 |  Score2 |
  ________________|_______________________|_________|_________|
                  |                       |         |         |
  New South Wales |  Albury (C)           |  979    |   967   |  
                  |  Armidale Dumaresq (A)|  987    |   985   |  
                  |  Ashfield (A)         |  1015   |   1031  |
  ________________|_______________________|_________|_________| 
  Victoria        |  Alpine (S)           |   987   |   970   |
                  |  Ararat (RC)          |   951   |   938   |
  ________________|_______________________|_________|_________| 
  </pre>
  
  <p>Now, I want to upload it in <strong><code>SQL</code></strong> via <strong><code>BCP or OPENROWSET</code></strong>. But the catch is for the records missing the state name, I want to copy over the initial declared state name.</p>
  
  <p>For example, in <strong><code>row# 2</code></strong> above. I want the <strong><code>StateName</code></strong> to be <strong><code>"New South Wales"</code></strong> for city of <strong><code>"Armidale Dumaresq (A)"</code></strong>. How can I do it using <strong><code>sql bulk load</code></strong> ? I don't really want to create a new app only for this small thing. Any solution would be appreciated.</p>