example.sql

SELECT
   es.SubCategoryName
  ,es.ClientProductID
  ,es.ProductSID
  ,CAST(ps.DATE AS DATE) DATE
  ,Price
  ,Cost
FROM ProductStatus ps
JOIN v_EnterpriseStructure es ON es.ProductSID = ps.ProductSID
JOIN PriceZone pz ON pz.PriceZoneID = ps.PriceZoneID
WHERE es.ProductSID = '9577C393-833B-4ACB-9A8E-8B748C65A488'
AND CAST(ps.DATE AS DATE) = CAST('2014-12-17' AS date)
GROUP BY
   es.SubCategoryName
  ,es.ClientProductID
  ,es.ProductSID
  ,ps.DATE
  ,ps.Price
  ,ps.Cost;

  
  or
  

SELECT es.SubCategoryName, es.ClientProductID, es.ProductSID, CAST(ps.DATE AS DATE) DATE, Price, Cost
FROM ProductStatus ps
JOIN v_EnterpriseStructure es ON es.ProductSID = ps.ProductSID
JOIN PriceZone pz ON pz.PriceZoneID = ps.PriceZoneID
WHERE es.ProductSID = '9577C393-833B-4ACB-9A8E-8B748C65A488'
AND CAST(ps.DATE AS DATE) = CAST('2014-12-17' AS date)
GROUP BY es.SubCategoryName, es.ClientProductID, es.ProductSID, ps.DATE, ps.Price, ps.Cost;