--I've used something like this to generate date lists...
--First, you need a way to generate rows:
create function [dbo].[GenerateRows](@MaxRows int) returns table
as
    return (
        with N1(...