Apply ISNULL Function in multiple Select query in SQL Server

alhamd

SOLVED CLOSED ACTIVE ANSWERED
User: alhamd
Posted: on Sep 06, 2023 01:48 AM
Forum: SQL Server
Answer: 1
Views: 708

I am trying to apply ISNULL function in the following but unable to implement. here is my query

SELECT 
(
    (select Sum(TotalPrice) from tblDispatchLocal) + (select Sum(P_Price) from tblSalesTran) + (select Sum(R_Amount) from tblLoanRefund)) 
	- 
    (SELECT ((select Sum(Price) from tblConsumption) +  (select Sum(Rate * Qty) from tblConsumptionMedicine)
	+ 
	(select Sum(Cost) from tblBreading) + (select Sum(Price * Quantity) from tblTreatment ) + (select Sum(P_Price) from tblPurchaseTran where P_Head='Expenditure')
	+ 
	(select Sum(Paid_Amount) from tblSalaryGenerate) + (select Sum(L_Amount) from tblLoan ) + (select sum(P_Amount)from tblExpenditure where Code in ('1','2','3','4'))
	+ 
	(select sum(P_Amount) from tblExpenditure where Code not in ('1','2','3','4') )
)
) ' Profit & Loss';

how to apply and get solution plz

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 06, 2023 01:48 AM
Report

Hi alhamd,

Refer

SELECT 
(
    ISNULL((select Sum(TotalPrice) from tblDispatchLocal),0) + ISNULL((select Sum(P_Price) from tblSalesTran),0) + ISNULL((select Sum(R_Amount) from tblLoanRefund),0)) 
	- 
    (SELECT 
	(
		ISNULL((select Sum(Price) from tblConsumption),0) +  ISNULL((select Sum(Rate * Qty) from tblConsumptionMedicine),0)
		+ 
		ISNULL((select Sum(Cost) from tblBreading),0) + ISNULL((select Sum(Price * Quantity) from tblTreatment ) + (select Sum(P_Price) from tblPurchaseTran where P_Head='Expenditure'),0)
		+ 
		ISNULL((select Sum(Paid_Amount) from tblSalaryGenerate),0) + ISNULL((select Sum(L_Amount) from tblLoan ) + (select sum(P_Amount)from tblExpenditure where Code in ('1','2','3','4')),0)
		+ 
		ISNULL((select sum(P_Amount) from tblExpenditure where Code not in ('1','2','3','4') ),0)
	)
) ' Profit & Loss';

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Apply ISNULL Function in multiple Select query in SQL Server

Company

Explore

Follow us

Contact Us