Or you could use another variable that is set to a particular value when a
condition meets, and check the variable in the WHILE along with
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
"exBK" <chikkodi> wrote in message
I found an answer (use GOTO) .. Thanks.lot>-----Original Message-----
>I have two cursors - an outer and an inner. In the inner
>cursor, I check for a condition, and if the condition is
>met, I want get out of both inner and outer cursors and
>deallocate them. How can I accomplish this ? Thanks a>for your time !!.