title: Expecting a single column argument with possible 'Child' qualifier
body: <p>This is my code</p>
  
  <pre><code>public void loadNumberOfAgents() 
  {
      string vmpstring = ConfigurationManager.ConnectionStrings["vmpMMProDat"].ConnectionString;
      SqlConnection vmpsqlcon = new SqlConnection(vmpstring);
      SqlCommand vmpCmd = new SqlCommand("SupGetAgentsWithInteractions", vmpsqlcon);
  
      SqlDataAdapter DAvmp = new SqlDataAdapter(vmpCmd);
      DataSet DSvmp = new DataSet();
      DSvmp.Clear();
      DAvmp.Fill(DSvmp);
  
      DataTable table;
      table = DSvmp.Tables[0];
      int numberOfAgents;
      Int32.TryParse(table.Compute("Count(*)", "").ToString(), out numberOfAgents);
  }
  </code></pre>
  
  <p>I got this exception</p>
  
  <blockquote>
    <p>Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier.</p>
  </blockquote>
  
  <p>on the last line of my code.</p>
  
  <p>When I execute the stored procedure in SQL Server 2005, I got this:</p>
  
  <p><img src="https://i.stack.imgur.com/mz8OG.png" alt="enter image description here"></p>