Posted by bbla32 on 02/19/07 23:53

> when DM.ReceiverDepartmentID is null, it returns 1 instead of 0?


I changed to

WHEN DM.ReceiverDepartmentID IS NULL OR DM.ReceiverDepartmentID NOT
IN ...

and

WHEN DM.StationID IS NOT NULL AND DM.StationID IN ...

I suppose it should be ok now.

• Next in forum: SQL 2005 AND SQLXMLBulkLoad
• Prev in forum: Re: a substitute for UNION?
• Thread view: Re: a substitute for UNION?

[Reply to this message]