Trust me, you...

Agreed, Jeff. There are at least a half a dozen better ways to do this.

Jeff Moden (12/25/2009)

---

RBarryYoung (12/25/2009)

---

OK, here it is...

To register for the Philadelphia SQL Saturday Event go HERE.

To apply as a Speaker and enter a Proposed Session go HERE.

And...

Heh. Man I hear that...

Solomon: OK, that's good. Thanks for the direction on that and I'll let you know when ever I get the chance to pursue this further...

-- Thanks Again, 🙂

OK, Solomon, here's a quote from Jon Skeet at his C# site (http://www.yoda.arachsys.com/csharp/csharp2/iterators.html), that I think explains what I am getting at:

As mentioned before, yield break is used to stop...

Solomon Rutzky (12/25/2009)

---

RBarryYoung (12/24/2009)

---

However, "yield break" is another story altogether. I have not heard of any way by anyone of a way to emulate a "yield break" in Vb other...

Heh, glad I could help,Jeff. 🙂

And as far as things coming full circle, yeah. "The more things change the more they stay the same". Or as I...

Jeff Moden (12/24/2009)

---

Heh... like Jackie Chan's Uncle says in the cartoon, "And one mo ting!"

There is a way to totally obfuscate the cross-joins if you ever need to do such...

OK, here it is...

To register for the Philadelphia SQL Saturday Event go HERE.

To apply as a Speaker and enter a Proposed Session go HERE.

And to just learn more, go to...

And of course, Streaming is a dream for scalability. You no longer have worry about scaling up physical memory to match the size of your Import/Export datasets, if they...

Jeff Moden (12/24/2009)

---

...Do you think this streaming method will solve the memory issues on extremely large files? If it does, then that makes this article really worth the price...

Yup, turns out you (and actually me too!) were 100% correct,and in fact one of the co-chairs worked it all out at PASS, I just never got the word. ...

I agree too. Dev Edition has *everything*, it's a really sweet deal for learning (and developing) SQL Server!

Solomon Rutzky (12/24/2009)

---

RBarryYoung (12/24/2009)

---

Actually, Jeff, the line-splitting functions and (less often)parsing functions are usually best done as TVF's, whether SQL or CLR. Unfortunately, as Matt pointed out, CLR TVF's...