Status: Solved
Priority: Medium
Security: Public
Views: 380
Last Modified: 2013-06-05

SQL 2008 SELECT

Hello,
Can you please help,
I'm trying to do a simple select.

SELECT * FROM ScanItem where scanin is Null (I get proper results - all data )
SELECT * FROM ScanItem where scanin is Null and CCDriverNumber is NULL (I get proper results)

When I add another AND, I get no results. (i SHOULD GET FEW HUNDERED)
SELECT * FROM ScanItem where scanin is Null and CCDriverNumber is NULL AND CCDriverNumber <> 2529

What am I missing?

thanks

W.E.B

Asked: 2013-06-05

Advertise Here

Microsoft SQL Server 2008

1 Solution

LVL 16

santoshmotwaniCommented: 2013-06-05

SELECT * FROM ScanItem where scanin is Null and CCDriverNumber is NULL
union all
SELECT * FROM ScanItem where ccdriverNumber <> 2529

or

SELECT * FROM ScanItem where scanin is Null
and
((ccdriverNumber <> 2529) or (ccdriverNumber is null))

W.E.BAuthor Commented: 2013-06-05

This did it, thanks

W.E.BAuthor Commented: 2013-06-05

Thanks

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

SQL 2008 SELECT

Join & Write a Comment Already a member? Login.

Featured Post