title: Combine Loop Query Results into 1
body: <p>I have a loop that queries a SP and returns results in a query, I want to combine that query (however many times the loop runs) into one final query so I can output in my jgrid table. Here is the code:</p>
  
  <pre><code>  &lt;cfloop query="query1"&gt;
        &lt;cfstoredproc procedure="[Columns]" datasource="#CompanyDB#"&gt;
          &lt;cfprocresult name="queryResults"&gt;
          &lt;cfprocparam cfsqltype="cf_sql_varchar" value="#query1.ID#"&gt;
          &lt;cfprocparam cfsqltype="cf_sql_varchar" value="#query1.Role#"&gt;
      &lt;/cfstoredproc&gt;
    &lt;/cfloop&gt;
  </code></pre>
  
  <p>So, here it loops 2 times hence I get 2 queryResults. I want to combine the results into 1 big query so I can then output in jGrid query. </p>