Merhaba

Bir MSSQL veritabanında bir sorgu hazırlıyorum.
İstediğim şu OperationDate alanında stock tarihleri tutuluyor.

Store a göre gün gün envanterleri listelemek istiyorum. Nasıl yapabilirim?

Sorgum şöyle;

 SELECT

 Inventory.StoreCode,
 Inventory.StoreDescription,
 Inventory		= 	SUM (Inventory),
 InventoryAmount  =		SUM(InventoryAmount)

 FROM (

 SELECT 
 
 StoreCode,
 StoreDescription		= ISNULL((SELECT CurrAccDescription FROM cdCurrAccDesc WITH(NOLOCK) WHERE cdCurrAccDesc.CurrAccTypeCode = 5 AND cdCurrAccDesc.CurrAccCode = trStock.StoreCode AND cdCurrAccDesc.LangCode = 'TR') ,SPACE(0)),							 

 Inventory		= SUM(In_Qty1-Out_Qty1),
 InventoryAmount  =	SUM(In_Qty1-Out_Qty1) * PurchasePrice.Price 

 FROM dbo.trStock WITH(NOLOCK)

 LEFT OUTER JOIN
    (
        SELECT prItemBasePrice.ItemCode,
               Price
        FROM prItemBasePrice WITH (NOLOCK)
        WHERE prItemBasePrice.BasePriceCode = 2
              AND prItemBasePrice.ItemTypeCode = 1
    ) PurchasePrice
	ON PurchasePrice.ItemCode = trStock.ItemCode

 WHERE

 ItemTypeCode = 1
 AND OperationDate BETWEEN @StartDate AND @EndDate
 AND dbo.trStock.OfficeCode <> 'M'



 GROUP BY StoreCode, PurchasePrice.Price

 ) AS Inventory

 GROUP BY  Inventory.StoreCode, Inventory.StoreDescription