A great discussion of Numbers tables by Jeff Moden here: http://stackoverflow.com/a/2663232

This page has sample code to create one and some examples of its use: http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=NumbersTable#CreateTable