Break Numbers List Into Min and Max Ranges

Question

Brain is not working today and my google skills are failing me.

I have a column of numbers ranging from 1 - 1000. I want to dump the min and max values for 100 (or whatever I chose) record ranges into a temp table. The plan is to use this temp table to process ranges of records (in this example 100 at a time) in a larger table.

Swear I have done this before with a CTE but then I had something to group on. Here I just want to break up a single list of numbers into ranges of X.

The output from the temp table should look like:

Min Max 0 99 100 199 200 299 300 399

etc.

Thanks!

Answer 1

You can use this trick from Stuart Ainsworth:

http://codegumbo.com/index.php/2009/01/25/building-ranges-using-a-dynamically-generated-numbers-table/

Numbers tables are awesome, but he uses a dynamically generated numbers table, which is even awesome...r.