Is Null in Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Is Null in Query

Author

Topic

jrockfl
Posting Yak Master

223 Posts

Posted - 2004-07-19 : 08:59:54

Of of values returns null in some cases, so it wont return a value. I'm trying IsNull, but I get an error saying it requires two arguments.

H.Domestic doesnt return a value in some cases, so it wont display OutboundSales, even though I.Outboundtotal has a value.

Here is the condensed query.

SELECT A.slspsn_no, A.slspsn_name, B.Callsout, C.Callsin, D.minsout,
E.minsin, F.Kount + G.Tount AS outcalls, IsNull(H.Domestic + I.Outboundtotal) AS
OutboundSales
FROM ARSLMFIL_SQL A

jrockfl
Posting Yak Master

223 Posts

Posted - 2004-07-19 : 09:01:29

I think I got it now...
SELECT A.slspsn_no, A.slspsn_name, B.Callsout, C.Callsin, D.minsout,
E.minsin, F.Kount + G.Tount AS outcalls, IsNull(H.Domestic, 0) + I.Outboundtotal AS
OutboundSales
FROM ARSLMFIL_SQL A

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources