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....
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.