How do I make conditional sql query.

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

General SQL Server Forums

New to SQL Server Programming

How do I make conditional sql query.

Author

Topic

a_self_lion
Starting Member

6 Posts

Posted - 2010-07-28 : 05:19:42

[code]SELECT ENVG_ML,SML_ISM,ENVG_DV_MK,ENVG_GR_MK,ENVG_URT_MK,ENVG_ART_MK,ENVG_RZG_MK,
ENVG_CIK_MK,ENVG_IML_MK,ENVG_EKS_MK,ENVG_HAS_MK,ENVG_IAD_MK,ENVG_SAT_MK
FROM GECENV
LEFT OUTER JOIN STKMLZ ON SML_KOD = ENVG_ML
WHERE ENVG_DEP = '13' AND
ENVG_TAR = '2010-07-01' AND
((ENVG_ML BETWEEN '11' AND '12') OR
(ENVG_ML BETWEEN '12' AND '14'))
[/code]

Hi Friends.
All of this material is coming in my query.
I want to do here,
If provided QUERIES IF I BRING ALL of the following conditions should
[code]
ENVG_DV = 0
ENVG_GR = 0
ENVG_URT = 0
ENVG_ART_MK = 0
ENVG_RZG_MIK = 0
ENVG_CIK_MK = 0
ENVG_IML_MK = 0
ENVG_EKS_MK = 0
ENVG_HAS_MK = 0
ENVG_IAD_MK = 0
ENVG_SAT_MIK = 0

[/code]

If the RIGHT BRING ALL THE ABOVE CONDITIONS let
BUT AN EVEN 0 DAN TWO of VALUE if you BRINGHow can my QUERIES INTEGRATION above this query.
FRIENDS COME EASY you. Thank you in advance.

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-07-28 : 05:57:31

please be more clear with what you need. thank you

a_self_lion
Starting Member

6 Posts

Posted - 2010-07-28 : 06:41:13

.. AND NOT (ENVG_DV = 0 AND
ENVG_GR = 0 AND
ENVG_URT = 0 AND
ENVG_ART_MK = 0 AND
ENVG_RZG_MIK = 0 AND
ENVG_CIK_MK = 0 AND
ENVG_IML_MK = 0 AND
ENVG_EKS_MK = 0 AND
ENVG_HAS_MK = 0 AND
ENVG_IAD_MK = 0 AND
ENVG_SAT_MIK = 0)

TANKS. I solved my problem.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources