Jeff Moden (12/17/2008)
Brandon,Not sure what the text editor you used may have done to you, but there's a lot of missing spaces in your code... for example CREATE TABLE has become CREATETABLE and SET @variable has become SET@variable. There are many other accidental concatenations throughout the code. It might be why there's not much discussion or rating on this article, so far... people just don't wanna take the time to fix posted code.
The "Text Editor" I used was SQL Server Management Studio for all SQL Code. The tested and working code was then copied into the article which is a word document typed in OpenOffice. I then emailed the entire DOC file to Steve so it is something in the publishing that is causing it.
Also, you may want to add a link to your article on how to build your numbers table... it would help people that just don't know about such things, a lot. Either that, or it's short enough to just use in the code.
Good idea. When I submitted this one, the first hadn't been published yet for me to include the link. I will have to go back and do it now.
Contact Steve Jones for how to edit your article if you're interested in doing such a thing. It's not difficult and Steve is very happy to help on these things.
Great idea and I will do that and fix them both up because this happened with the first one too.