Q. How to write Query for Cumulative calculatin in sql server?

Ans.

SELECT DISTINCT A.Sl_Weight_No, CONVERT(DATE,A.Site_Weighment_Date_Time) as SITEDATE, A.Site_Weighment_Date_Time as Date_Time
,substring(A.Lot_No,5,20) as Lot_No,
 A.SW_No_of_Nets as No_of_Nets_Wt,
 A.SW_Tare_Weight as Net_Tare_Wt,
 A.SW_Total_Weight as Total_Weight,
 A.SW_Total_Tare_Weight as Total_Net_Wt,
 A.SW_Net_Weight as Net_Weight,
 SUM(B.SW_Net_Weight) as Cumulative_Wt
   from Site_Weight_Details A inner join Site_Weight_Details B on A.Sl_Weight_No >= B.Sl_Weight_No

  GROUP BY  A.Sl_Weight_No,A.Site_Weighment_Date_Time 
,substring(A.Lot_No,5,20),
 A.SW_No_of_Nets ,
 A.SW_Tare_Weight ,
 A.SW_Total_Weight ,
 A.SW_Total_Tare_Weight ,
 A.SW_Net_Weight ORDER BY A.Sl_Weight_No