John -
It sounds to me that you want to use a Tally table. it will allow you to return the desired amount of rows needed.
Here's a good primer on how to use it:
http://www.sqlservercentral.com/articles/TSQL/62867/[/url]
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?