Who can help me with the following task?
I have a table with ordered Ids while some ids are missing(For example: 1,2,3,4,5,7,8,9,10,11,14,15…).
I need it into cursor with the following structure:
The cursor will include two columns:
1. from, 2. to.
Based on the following concept:
If the next number in the table source >1 from the previous, the cursor will hold it other line (in the previous example, this will be the cursor lines:
From 1 to 5
From 7 to 11
From 14 to 15).
It's very important for me.
Thanks for help
Chaim