Posted by diego on 01/07/07 04:29
Greetings everyone!
Is there a way to stop query analyzer from processing remaining query
statements? Let's say i have the following query in query analyzer:
query statements
if condition
begin
query statements
stop the query
end
query statements
if condition
begin
query statements
stop the query
end
is there a way to stop the query from executing the statements in the
second query when the first condition is met?
i have searched BOL and google but i couldn't find anything. I hope
anybody out there can help me.
BTW, i'm executing this statements directly in QA, not from within my
program. The query statement and if condition pair is plenty. i guess i
can use an else statement but it would be nested too deep. if there is
a simpler way to do it please point me to the right direction or to any
link that'll get me going.
Thanks in advance.
diego
[Back to original message]
|