This content has been marked as final. Show 3 replies
1. When insert is happening only for table A, i guess there is no need to think about 11-100 rows or similar numbers for table B insertion
2. For the trigger part use the row count of the table and execute accordingly whether to insert a row in table B.
3. Using the remainder logic will do the trick (1-10 divided by 100 - remainder 1-10)
(11-100 divided by 100 - remainder (0,11-99)
Same applies for values between 100-200 and so on
Hope this helps