Hi guys,

I need to get the numbers that were skipped between two given numbers.

Example: Mytable.dbo contains the following records

orno amount
1 ---- 1,000
3 ---- 5,000
6 ---- 2,000
8 ---- 3,000


Is it possible to query this table so that I could get the orno numbers that were skipped? (2,4,5,7,9,10) provided that the 2 given numbers is 1 to 10 ?


Thanks in advance....