title: invoke-sqlcmd fails shows no results on certain type of queries
body: <pre><code>Invoke-Sqlcmd -ServerInstance '.' -Database 'MyDB' 
        -Query 'EXEC SprocA  @param1= "value";EXEC SprocB  @param1= "value";'
  </code></pre>
  
  <p>Basically I have my <code>Invoke-SqlCmd</code> running a query that invokes two stored procedures. Both the stored procedures output a bunch of rows.</p>
  
  <p>However if <code>sprocA</code> does not output any results (empty select results or no rows), then the invoke command does not seem to print the output of the second <code>sprocB</code> even if it has data.    </p>
  
  <p>If I change the order of the stored procedures in my <code>Invoke-SqlCmd</code> commands query parameter, then this works perfectly and returns the output of the first stored procedure.</p>
  
  <p>If I had three stored procedure calls where the first returns data and the second does not and the third does, it prints output of the first result and third result.</p>
  
  <p>Basically it does not print any output only if the first stored procedure has no output. Seems weird.</p>
  
  <p>Anything I can do to get around this SQL wise ? Could be a PowerShell thing?</p>
  
  <p>I was also able to repro this with two <code>Select</code> statements where one returns data and the other does not.</p>