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

• Next in forum: Re: How to stop query in QA from continuing
• Prev in forum: Re: Idea: new database object that defines a FROM clause
• Thread view: How to stop query in QA from continuing

[Reply to this message]