The article was nice. I hopoe the code is right. But when I tried to run the code I am getting error in the Insert statement.
BEGIN
INSERT INTO CaseDetail VALUES(200,300,1)
SET @count = @count -1
END
I am not having time to check the error but do we require to write the column names in the syntax. I may done some silly mistakes also.