My conviction is that this so called technology is all crap, they think they got...

Rating different qualities is a fairly easy thing to do in my view.

If you need two qualities in equal demand and they are mutually exclusive the one that is hardest...

There always is some sort of taboo on this subject as it shows a lot of our inner workings we do not necessarily like to make so visible to others....

Technology

This one word has conquered the marketing world, has been entrenched for years now, and in doing so has become absolutely meaningless!

Every product, architecture and marketing feature is now generally...

Where I work DD is used a lot by the other developers, so everyone but me as I very much dislike it.

The problems I have with it are:

1. It...

Jeff Moden (5/9/2009)

---

Peter,

Sorry man. I tested against 1000 lines of 800 comma separated random numbers each in a VARCHAR(8000) environment... your code did the split into a table at...

Manie Verster (5/9/2009)

---

Thanks to all for jumping in to help me but that was not quite the reason for me posting the code. I thought Ha! let's see how they...

Thanks for the information Jeff...care to take a quick look at what your string splitter evolved into as well?

PS.

I see still room for improvement for the classic method..my strategy is...

Me again....

I modified the classic Tally solution for string splitting as found on the initial pages and made speed improvements.

This solution is unlikely to suffer from the predictable data problem...

Here is an update to my tally function, it has now slightly less overhead by eliminating two cross joins. I did this by moving from a 4 bit (0-16) constant...

I did some testing myself using the testsuite Jeff made a few posts back. Thanks, it ran good first time....and on my machine (a pretty fast one) the timings indicate...

Hi gents,

I have been following the discussion, half and from a large distance, so I ain't really in the loop...so to speak ;).

I was wondering how this tally function that...

JohnG (5/1/2009)In SQL Server have you ever wanted to conditionally consume (e.g., loop through) the result set returned by a stored procedure? For example, the output returned by the...

In my opinion sending mail from within SQL server is only sensible for maintenance reports for DBA's and the occasional alert if something goes wrong.

I sincerely doubt it was ever...

I haven't taken a shot at this new problem yet, waiting for replies to the "gserdijn" solution first :). I did take a look at the problem code however and...