I'm working on some procedures where I need conditional execution of
The main part of the procedure:
--Get the current CUT_NO from underlying tables.
select CUT_NO = ......
-- The problem: If CUT_NO = 0 I need to execute some code, and If
CUT_NO <> 0 some other code
IF (CUT_NO = 0)
select tmpLENGTH_MM = 1000
select tmpLENGTH_MM = 200
END -- < I get an error on this line
After this END, more statements occur that will be executed regardless
of the value in CUT_NO
Which approach ...