Re: WHERE Clause

This is why I asked for help - how do I use nested selects? Why shouldn't I use
OR?

Hi,

I am having trouble with 2 Where clauses - I am trying to adjust them so that
they keep the former meaning but also add an extra stipulation.;

  WHERE (([Z] = @Z) AND ([A] >= @A)) AND (([B] < [C]) OR (([B] = 0) AND
([C] = 0)))

 for this, I would like the second bracket set to apply as long as [C] < [P].
So I'd like to 'check' that C is less than P.


Would this work:  WHERE (([Z] = @Z) AND ([A] >= @A)) AND (([C] < [P]) AND
(([B] < [C]) OR (([B] = 0) AND ([C] = 0))))    ?


 

 

WHERE (([A] <= @A) AND ([D] = @D)) OR (([B] >= [C]) AND (([B] > 0) AND
([C] > 0))) AND ([D] = @D)) AS LogWithRowNumbersList

for this one, I would like the second set to apply as long as [C] >= [P]...

Would this work: WHERE  (([A] <= @A) AND ([D] = @D)) OR (([C] >= [P]) AND
(([B] >= [C]) AND (([B] > 0) AND ([C] > 0))) AND ([D] = @D))) AS
LogWithRowNumbersList    ?


 

Thanks for your help,

Jon

Well we don't know. Did it work? You are the only one how can actualy test that
mess. I word of advice thou, don't use or avoid to use OR. Try to use nested
selects, between ()

Give me dummy data like "this is my table:" and copypaste some rows .
Then tell me what the outcome is supposed to look like. See this post to
understand what i mean: Post

It takes to long for the engine to deal with it. Give me an example of data...
so i can play with it and the return format you want.