select row_number() over(order by O.Col_Id) as SlNo, O.Col_Date,Account_No,Scheme_Name,O.Col_No,Instalment_Amount,O.No_Of_Instalment,O.Col_Amount ,Permanent_Address, (select sum(Col_Amount) from t_Customer_Deposit where Col_Id <= O.Col_Id and Col_Customer_Id=1) as 'Running_Total' from t_customer_account inner join t_customer_deposit O on t_customer_account.customer_id=O.col_customer_id inner join t_scheme_master on t_customer_account.scheme_id=t_scheme_master.scheme_id where customer_id=1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)