title: Sqlcmd to generate file without dashed line under header, without row count
body: <p>Using the following sqlcmd script:</p>
  
  <pre><code>sqlcmd -S . -d MyDb -E -s, -W -Q "select account,rptmonth, thename from theTable"  
  &gt; c:\dataExport.csv
  </code></pre>
  
  <p>I get an csv output file containing </p>
  
  <blockquote>
    <p>acctnum,rptmonth,facilname </p>
    
    <p>-------,--------,---------<br>
    ALLE04,201406,Allendale Community for Senior Living-LTC  APPL02,201406,Applewood Estates 
    ARBO02,201406,Arbors Care Center<br>
    ARIS01,201406,AristaCare at Cherry
    Hill<br>
    . . .      </p>
    
    <p>(139 rows affected)</p>
  </blockquote>
  
  <p>Is there a way to get rid of the dashed line under the column headers : -------,--------, but keep the column headers? </p>
  
  <p>and also a way to get rid of the two lines used for the row count on the bottom?</p>
  
  <p>I tries using parm -h-1 but that got rid of the column headers as well as the dashed line. </p>