Below is data, when ever two time Imp_Container_No exit with same name,then it imp_Inv_Value and Inv_Weight will get sum below is data. Total=imp_Inv_Value*Inv_Currency_Pkr
Create table #tbl_Account_L_Five (Level_Five_Id int,Level_Five_Name varchar(50))
Create table #tbl_Imp_Master_Heco (Imp_ID int,
Imp_Ship_Code varchar(50),
Imp_Currency_Rate decimal(10,2),
Imp_Container_No varchar(50),
Level_Five_Id int,
Imp_Date date,
)
Create table #tbl_Imp_Invoice_Heco
(ID int,Imp_Inv_ID varchar(50),imp_ID int,imp_Inv_Value Decimal(10,2),Inv_Weight Decimal(10,2),Inv_Currency_Pkr Decimal(10,2)
,Imp_Supplier_Asset_ID int,Imp_Currency_Rate Decimal(10,2),
Imp_Supplier_Libility int,Imp_Code varchar(50))
insert into #tbl_Account_L_Five values (10001,'Akhter')
insert into #tbl_Account_L_Five values (10002,'Jhoni')
insert into #tbl_Account_L_Five values (10003,'Kami')
insert into #tbl_Account_L_Five values (10004,'Sami')
insert into #tbl_Imp_Master_Heco values(111,'Has-001',150,'Abc123',10004,'2021-06-01')
insert into #tbl_Imp_Master_Heco values(112,'Has-002',150,'Abc122',10004,'2021-06-02')
Insert into #tbl_Imp_Invoice_Heco values(1,'INV_01',111,105,502.2,150,10002,142,null,'Imp_01')
Insert into #tbl_Imp_Invoice_Heco values(2,'INV_02',112,751,222.2,150,10003,140,null,'Imp_02')
Insert into #tbl_Imp_Invoice_Heco values(3,'INV_12',112,222,512,250,10002,140,null,'Imp_03')


