Hi,
Kindly Guide.
I have a cursor with field fObjectno N(20) which contains Numbers Like 1,4,14,15,12,17,2,3,7,10,13 etc on Random basis.
The lowest is 1 and Highest is 17 in the above case. I need to create a table of Missing Numbers from the above series. I.e The Missing Numbers between the Lowest and Highest in the Table.
Is there any Simple way or SQL to do it in speed.
The Range may be Between 1 to 10000 and it is not necessary that 1 will in the top or 10000 will be at the bottom of the cursor.
I need Missing Figures in a Cursor (Difference in Numbers=1)
Thanks
Harsh