Null Fields / Zero Values Problem

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 2005 Forums

Transact-SQL (2005)

Null Fields / Zero Values Problem

Author

Topic

Jonny1409
Posting Yak Master

133 Posts

Posted - 2008-07-25 : 06:11:12

Hello,

I am having a problem with zero values, and I'm sure there is a simple way to fix it, but I don't know what it is.

Basically I have a view built up from a couple of other views.
Two of the fields (BookedDays and BookedHours) in my current view are showing as Null for certain employees (which is correct)

However, in order to use this view, I would like the Nulls to be 0 instead.

How can I do this ?

My view is :


SELECT                dbo.tbl_EmployeeDetails.EmployeeNumber,
                      dbo.[vw_HolidaysBookedPerEE(Total)].BookedDays, 
                      dbo.[vw_HolidaysBookedPerEE(Total)].BookedHours
FROM                  dbo.[vw_HolidaysBookedPerEE(Total)] 
RIGHT OUTER JOIN      dbo.tbl_EmployeeDetails ON dbo.[vw_HolidaysBookedPerEE(Total)].EmployeeNumber = dbo.tbl_EmployeeDetails.EmployeeNumber 
LEFT OUTER JOIN       dbo.[vw_ReserveHolidaysPerEE(Total)] ON 
                      dbo.tbl_EmployeeDetails.EmployeeNumber = dbo.[vw_ReserveHolidaysPerEE(Total)].EmployeeNumber 
LEFT OUTER JOIN       dbo.[vw_FutureHolidaysPerEE(Total)] ON dbo.tbl_EmployeeDetails.EmployeeNumber = dbo.[vw_FutureHolidaysPerEE(Total)].EmployeeNumber

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-25 : 06:16:18

use isnull() or coalesce()

eg.
isnull(yourcol, 0)

KH
[spoiler]Time is always against us[/spoiler]