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.
| Author |
Topic |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2008-01-14 : 16:24:01
|
| I have a select query i want to add a where conditionWHERE a.EnterpriseLevelAccess <> 'None' and a.EnterpriseLevelAccess <> 'Contract' or can i do the following:WHERE a.EnterpriseLevelAccess <> 'None','Contract'Is it possible to put all conditions for Enterpriselevelaccess at a time with a comma seperated?Thank you very much for the information. |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2008-01-14 : 16:25:01
|
| WHERE a.EnterpriseLevelAccess NOT IN ('None','Contract') |
 |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-01-14 : 16:25:12
|
WHERE a.EnterpriseLevelAccess NOT IN ('None','Contract')11 seconds too slow  |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2008-01-14 : 16:26:08
|
I won  |
|
|
|
|
|
|
where condition