SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

15 rows affected

Declare @StartDate date='2022-02-01'
Declare @Enddate date ='2022-02-15'

SELECT C.CID, C.ContNo, C.entrydate AS IN_Date, 
  -- CAST(C.ConWeight AS DECIMAL(10,4)) AS ConWeight,
  -- CAST(COALESCE(I1.IWeight, 0) AS DECIMAL(10,2)) AS IWeight, 
  CAST(C.ConWeight AS DECIMAL(10,4)) - 
    CAST(COALESCE(I1.IWeight, 0) AS DECIMAL(10,2)) AS Opening_Weight,
  CAST(COALESCE(I2.IsuWeight, 0) AS DECIMAL(10,2)) AS IsuWeight,
  CAST(C.ConWeight AS DECIMAL(10,4)) - 
    CAST(COALESCE(I1.IWeight, 0) AS DECIMAL(10,2)) -
    CAST(COALESCE(I2.IsuWeight, 0) AS DECIMAL(10,2)) AS Closing_Weight
FROM Containerno C 
LEFT JOIN
(
  SELECT CID, SUM(IWeight) AS IWeight
  FROM ConIssuance
  WHERE EntryDate<@StartDate and DelID is null
  GROUP BY CID
) AS I1 ON C.CID = I1.CID
LEFT JOIN 
(
  SELECT CID, SUM(IWeight) AS IsuWeight
  FROM ConIssuance
  WHERE EntryDate BETWEEN @StartDate and @EndDate and DelID is null
  GROUP BY CID
) AS I2 ON C.CID = I2.CID
WHERE C.DelID is null AND C.entrydate BETWEEN @StartDate AND @Enddate

CID	ContNo	IN_Date	Opening_Weight	IsuWeight	Closing_Weight
3	ABC1333	2022-02-01	7800.0000	3000.00	4800.0000
4	ABC1444	2022-02-02	4500.0000	2000.00	2500.0000
5	ABC1555	2022-02-15	4700.0000	0.00	4700.0000
6	ABC1666	2022-02-15	5000.0000	0.00	5000.0000