Group Consecutive Numbers In a range

[bmacbmac]

Hi,
I have a table with 100,000 rows of bigint numbers:


2005041330
2005041331
2005041332
2005041333
2005041334
2005041337
2005041338
2005041339
2005041341
2005041342
2005041343
2005041347
2005041350
2005041351
2005041352
2005041353

I am looking for a way I can group this list into ranges... like this:
BegNumber EndNumber
2005041330 2005041334
2005041337 2005041339
2005041341 2005041343
2005041347 2005041347
2005041350 2005041353

This is for SQL 2000. Does anyone have an idea how I can go about this?

Thanks!

Brian

 

[markros]

Take a look at this blog post

http://pratchev.blogspot.com/2010/02/refactoring-ranges.html

PluralSight Learning Library

 

[bmacbmac]

Thanks markros. That blog post was perfect!