TheSQLGuru (10/5/2009)

---

For me it was Hunt the Wumpus, hand-coded on my TRS-80 Model III circa 1979. I think there was another one I did, something that started with a 'Z' - Zork, Zon? BTW, that "computer" had 4K of RAM and CASSETTE TAPE DRIVE EXTERNAL STORAGE - and I was the baddest *** geek for a hundred miles (small-town NC at the time). Oh, did I mention that my parents forked over $999 for it?!?! Man have we come a damn long way!

Peter Pirker (12/9/2009)

---

Have tried to run it (copy + paste) but get errors.
What could I be doing wrong?

Peter Pirker (12/9/2009)

---

Yes, I noticed - sorry to trouble you, and thank's for a great article.

the sqlist (9/22/2009)

---

Here is another version that WILL work on any SQL version and the code is pretty much self descriptive and easy to understand by everyone. I agree that might not have ALL the features the code in article has but almost all. Still has the start/end/increment values

where
number between @pStartValue and @pEndValue
and number % @pIncrement = 0

                      and (number - @pStartValue) % @pIncrement = 0 

Jeff Moden (10/2/2009)

---

--===== Find the "gap ranges"
     -- This assumes that gaps include any whole number greater than 0
 SELECT GapStart = (SELECT ISNULL(MAX(b.MyID),0)+1
                      FROM #MyTest b 
                     WHERE b.MyID < a.MyID),
        GapEnd = MyID - 1  
   FROM #MyTest a
  WHERE a.MyID NOT IN (SELECT MyID + 1 FROM #MyTest)

It also doesn't need a mega-row tally table.

  WHERE a.MyID NOT IN (SELECT MyID + 1 FROM #MyTest) and a.MyID > 1