I have two table A & B with same columns.
I want to create insert trigger on table A such that it will add first 1-10 rows to table A & B as well.But next 11-100 rows should be inserted in table A only not in table B.
For next 101-110 rows should be added to table A & B as well and continue.
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)