title: SQL query returning blank results
body: <p>When I run the query below, it returns no data! Does anyone know why that may be? </p>
  
  <pre><code>select 
      es.SubCategoryName,
      es.ClientProductID,
      es.ProductSID,
      CAST (ps.Date as date) as Date,
      Price as Price, 
      Cost as Cost 
  from 
      ProductStatus as ps
  join 
      v_EnterpriseStructure as es on es.ProductSID = ps.ProductSID
  join 
      PriceZone as pz on pz.PriceZoneID = ps.PriceZoneID
  where
      es.ProductSID = '9577C393-833B-4ACB-9A8E-8B748C65A488'
      and ps.Date = '2014-12-17' 
  group by
      es.SubCategoryName,
      es.ClientProductID, es.ProductSID,
      ps.Date, ps.Price, ps.Cost 
  </code></pre>
  
  <p>I know if you forget to put inverted commas around a date, you get blank results. </p>
  
  <p>But I'm not sure why it would happen here? </p>
  
  <p>I'm using SQL Server Management Studio 2014. </p>
  
  <p>TIA. </p>