title: insert into tables using select and values in SQL Server CE
body: <p>I have a query in which the syntax is correct (verified using SQL Server), but when I execute it for SQL Server CE, it gives the following error:</p>
  
  <pre><code>insert into HistoryPC (Date, Col1) 
  values ('12/02/2012', (SELECT COUNT(CASE WHEN i.ProductCode = 'XXX' and i.ProductCode = p.ProductCode THEN Quantity END) 
                         FROM Product p, Invoice_Details i 
                         left outer join Invoice_Header h on h.Invoice_NO = i.Invoice_No  
                         WHERE h.Date = '2012-06-02'))
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>There was an error parsing the query. [ Token line number = 1,Token line offset = 63,Token in error = SELECT ]</p>
  </blockquote>
  
  <p>What I want is to insert the date column of the table to be Today and other values using select. </p>
  
  <p>How can I do this?</p>