Thanks, Adam :blush:

Just a couple of suggestions, folks...

First, there is no need for a loop in the creation of a "Tally" or "Numbers" table. Second, to be truly effective and to...

Yes... the solution is posted above... the server must be logged into the domain as a user that can actually "see" the file path.

First, mailing you the solution wouldn't do anyone else any good...

Second, take a look at BCP in Books Online... it's likely your best bet.

Import 1 line and count the LEN difference between the line with delimiters and the line where the delimiters have been replaced with nothing and add 1 to that.

For fixed...

Chirag (2/6/2008)

---

Hi Jeff

I have a doubt abt the index selection when i ran your code

in the article ' Running total.......'

I created the table dbo.JBMTest , added the clustered...

Matt Miller (2/5/2008)

---

Jeff Moden (2/5/2008)

---

It IS a cool solution... Wasn't so good in the performance department on my machine, though... it took 29 minutes to do the million row example...

Perfect... another "convert" to denounce the evils of RBAR 😛

Thanks, for the feedback, Whitt. Real glad we could collectively make such a difference for you.

Tony McGarry (2/6/2008)

---

I prefer this simple and elequent way to generate numbers.

I doesn't generate unnecessary numbers and is easy to understand

[font="Courier New"]CREATE FUNCTION dbo.GetSequence

(

@Start BIGINT,

...

How in the world did you get parallel execution out of it? I've tried it on both a 4 CPU and an 8 CPU SQL 2k SP4 installation and...

Thanks for the retest, John 🙂

Sure... Matt and I go round'n'round... it's all in good nature and we both learn things in the process. Hopefully, everyone both understands that...

GSquared (2/6/2008)

---

Yet again, I have to say this is clever, but a Numbers table is better.

Yes, if you for some reason need to create a list of sequential numbers on...

Very nicely done, Jacob.

Please... not trying to take anything away from this great article... just sharing a different method...

As a slightly easier to remember (and, a bit faster, too) approach...

Sorry James,

It's a "numbers" table that consists of nothing but a column of well indexed sequential numbers. Matt, Peter (Peso), and a lot of the others know about it....

I pretty much agree with Matt... yeah, I'm all about speed and performance... but only when I've done job #1 which is to protect the data at any and all...