Flow Control in proc programming - IF...ELSE 1

[daglugub37]

This is currently working for me:
IF condition
BEGIN
Statements
END
ELSE
BEGIN
Statements
END


However I would like to get something like this to work with an IF nested:
IF condition
BEGIN
Statements
IF CONDITION
BEGIN Statements
RETURN
END
END
ELSE
BEGIN
Statements
END

I can't seem to get the syntax right; keeps erroring on the ELSE. Do I need some parens or brackets or something?

 

[mrdenny]

Your syntax should be fine. The return statement in the nested IF might be causing you a problem but it shouldn't be. I've used that exact syntax many times.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[daglugub37]

thanks you were right, and I guess I was too....but I did not have my code formatted like my example....I was trying to run the 2nd IF statements before the 1st BEGIN.

All set now thanks again for confirming the correct syntax template

 

[mrdenny]

that will definettly cause a problem.

Glad it's working.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)