title: MSChart with 2 data series - solve in SQL query?
body: <p>I have an MSChart control bound to a SQL query (single series).  All good.</p>
  
  <p>What I need now is to show two separate data series' as separate lines on the chart.  I can write separate queries to each return one of the data sets but I don't believe I can bind the chart control to two separate sqldatasources.</p>
  
  <p>What I can do currently is write the following query.  The two data series are for the average rating of products in two different price bands - 4 and 5 ($0-$10 and >=$10).</p>
  
  <p>SELECT band, AVG(L.rating) as Avg_Rating, date<br>
    FROM PriceBand P<br>
    join ListItem L on L.price >= P.loprice and L.price &lt;= P.hiprice and band > 3<br>
    group by band, loprice, hiprice, date<br>
    order by date, band  </p>
  
  <p>which returns data in this form:<br>
  2010-12-01 | 4 | 3.1<br>
  2010-12-01 | 5 | 3.6<br>
  2010-12-02 | 4 | 3.3<br>
  2010-12-02 | 5 | 3.9 </p>
  
  <p>Date, series, Value</p>
  
  <p>I believe I may need to get it to look like the following.</p>
  
  <p>Date, Value[4], Value[5].</p>
  
  <p>Question 1: Am I correct in the best way to organize the data in order to create the 2-value line chart?</p>
  
  <p>Question 2: If so, how can I rework the query to create that output?</p>
  
  <p>Thanks to all for taking the time to read this and/or assist.</p>
  
  <p>-Dan</p>