توی این کوری جایگزین کن جداول و اسم ستون ها رو
SELECT *,
(SUM(ISNULL(Final.varede, 0)) OVER ( PARTITION BY Final.IdKala ORDER BY Final.IdKala ASC , CAST(Final.CreateDate AS DATE) ASC ,CAST(Final.CreateDate AS TIME) ASC ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING )
-
SUM(ISNULL(Final.sadere, 0)) OVER ( PARTITION BY Final.IdKala ORDER BY Final.IdKala ASC , CAST(Final.CreateDate AS DATE) ASC,CAST(Final.CreateDate AS TIME) ASC ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING ))
AS Mande
FROM
(
SELECT
i.CreateDate ,
i.InputsNumber ,
'' AS OutputsNumber ,
CAST(NULL AS DECIMAL(25, 3)) AS sadere ,
id.Quantity AS varede,
id.IdKala
FROM WareHouse.Inputs i
JOIN WareHouse.InputsDetails id ON id.IdInputs = i.Id
WHERE i.IdCompanyToAnbar=5
UNION ALL
SELECT
i.CreateDate ,
i.OutputsNumber ,
'' AS OutputsNumber ,
id.Quantity AS sadere ,
CAST(NULL AS DECIMAL(25, 3)) AS varede,
id.IdKala
FROM WareHouse.Outputs i
JOIN WareHouse.OutputsDetails id ON id.IdOutputs = i.Id
WHERE i.IdCompanyToAnbar=5
)Final
ORDER BY Final.IdKala ASC,CAST(Final.CreateDate AS DATE)ASC,CAST(Final.CreateDate AS TIME) ASC