Jul 24, 2020 08:34 AM|yij sun|LINK
1 level_One_ID exit then it will be 11,then again check if 11 again level_One_ID exit then it will be 12.if there is not level_One_ID exit of 2 then 21 will be ,if 3 level_One_ID does not exit then level_Two_ID will be 31
Accroding to your description,I don't understand your requirment clearly.Could you tell us your reqiurment clearly and concisely.
Accroding to your query,I create a test and I could get Level_Two_ID=22.I'm guessing that you need to check the Level_One_ID then add 1 in Level_Two_ID.
You could post more details to us.It will help us to solve your problem.