I've used a function similar to MiddleDatestoTable in my apps, however I followed a different approach.

Create Function dbo.udf_NumbersTable (

@riStartingNumber Int, @riCount Int

)

Returns @tbl Table (SequenceNumber Int)

As

Begin

-- Logic used from

Interesting idea indeed! However there are obviously some limitations (maxrecursion being one of those), plus the performance 'may' not be up to the mark.

The best method to split a integer...