kinda like those Oldsmobile ads -- "this isn't your father's testing environment."

maybe best stated by Obi Wan Kanobi, "These aren't the test results you're looking for."

Phil

Glad I could help. I also think I spotted a typo in the article, but upon a re-read, don't see it.

Rather than recreating the UNIX epoch problem of a...

There are 86400 seconds in a day, not 84400 that you stated in the article. You should probably change some numbers.

@Gatekeeper

The article to which I referred is rCTE (recursive CTE).

Mark

@peter-2

Jeff's new article uses describes this method and states that the compiler knows that when the number of rows is less than what would be produced at/above one...

@Wayne

it depends on the ability to split the max string at a delimiter into <8000 sized chunks reliably. Otherwise, the ends of the parsed strings sets would...

@jeff

Here's an idea to kick around for varchar(max) data...use a tally table (or cte equivalent) to split the very large string into strings less than 8000 characters and...

As a VB guy, I'm pissed that the VB team in Microsoft's .Net team lost every decision battle to the C# team.

Thank you anyway, Anders, for Delphi. ...

SQLkiwi (5/14/2011)

---

peter-757102 (5/14/2011)

---

There was some chatter a while back about replacing T-SQL entirely. This would be a good thing, in my view, though it does rather depend on what...

To what running total function are you referring?

Yes. MS-Access has a field/column definition data type of autonumber (long integer or GUID/ReplicationID data type). The...

Jeff

The article has been published.

http://www.experts-exchange.com/A_5410.html

Enjoy,

Mark

Jeff

I just submitted it yesterday. It hasn't entered the editor review phase yet. I'd like to know what you think. I might be able to your incorporate...

SQLkiwi

Can people use ngen to compile the assembly and save the JIT overhead?

Jeff

This article inspired me to write a TallyTable article for Access users/developers.

And thanks to the other commenters for your patience and enlightening comments.

Mark