To find the difference in NULL values, Please help..

[#1]

I need to subtract null values(12495000 - 12494342) and display in DIFFERENCE column. Please help..

[rustyfishbones]

It depends on what you are trying to do

but you can change if it's a list box to treat a null symbol as 0

[#3]

I created a Chart as table with 2 data sources as part of ETL testing on the key  BUSINESS_PLAN_RCVD_DT_SBL:

1. SELECT (CASE WHEN PRTNR_TYPE_CD IS NOT NULL THEN c.[X_BUS_PLAN_RECVD_DT]
ELSE NULL
END) AS BUSINESS_PLAN_RCVD_DT_SBL, COUNT(1) AS BUSINESS_PLAN_RCVD_DT_SBL
from COMMON.dbo.W_SBL_S_EXT c

GROUP BY (CASE WHEN PRTNR_TYPE_CD IS NOT NULL
THEN c.[X_BUS_PLAN_RECVD_DT]
ELSE NULL
END)
ORDER BY 2;

2. SELECT BUSINESS_PLAN_RCVD_DT AS BUSINESS_PLAN_RCVD_DT_SBL,

COUNT(1) AS BUSINESS_PLAN_RCVD_DT_GDW

FROM GDW.dbo.T_DIM_ACCOUNT
WHERE SRC_APP_CD = 'SBL' AND SRC_DELETE_FLG = 'N'
GROUP BY BUSINESS_PLAN_RCVD_DT
ORDER BY 2;

thye both have NULL vallues but not in the same row..