Search
InstantDoc ID
GO

Browse By: Author | Issue

February 19, 2009 04:19 PM

Build the Numbers Table You Need

A custom tool that skirts the limitations that traditional techniques entail
Rating: (0)
Frank Solomon
SQL Server Magazine
InstantDoc ID #100531
Executive Summary:
CreateIntegersTable is a multistatement table-valued function written for Microsoft SQL Server 2005. You can use this custom tool to create a numbers table that works around nearly all the limitations that traditional techniques for building these tables usually involve. For example, traditional techniques might themselves involve cursors, loops, or identit...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Hi JC,

In response to your comment, Frank Solomon has provided a SQL Server 2000-compatible version of the code presented in this article. To access this code, click the 100531.zip link at the top of the article page under Download the Code.

Please let me know if you have any questions.

Thanks!

Megan Keller

Associate Editor, SQL Server Magazine

mkeller@sqlmag.com

Megan6/29/2009 12:35:12 PM

Hi. Great idea. At the risk of asking for something for nothing, I was wondering if you could post any suggestions on doing this in a SQL2k compatible version. Our office has -still- not upgraded and I am a bit confused on how to implement this without a CTE.

TIA,

---JC

JC3/7/2009 6:05:24 PM

Although I applaud the author for a well written article, there are many ways to effectively generate a list numbers... and recursion isn't one of them.

JEFF3/1/2009 7:08:34 PM

I see it's fixed!

Michael2/25/2009 7:49:20 AM

Uh oh, I don't know what happened to the article, but I'll get the problem fixed as soon as possible. Anne Grubb, web editor

Anne2/19/2009 11:32:39 AM

hmmm...
I see a title, author, instant doc #, then an ad and then...
the words "End of Article"

Michael2/19/2009 7:33:15 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.