Conan The Coder (1/14/2010)

---

If I'm doing something that is complex more than once, I try to do it once and save off the results so that I can refer back...

I come from a VBScript/VB.NET/OOP background myself, so I understand the subroutine concept! 🙂

I'm just trying to see how it's applicable to SQL. Since I've lived on both sides...

Another question (again, I think I understand, but I'm looking to clarify): how would a subroutine differ from a CTE? What would a subroutine do that a CTE can't...

I think I understand where you're going with this.

How would a subroutine work in a set-based, rather than a RBAR, environment?

If you have any examples to provide, please enlighten us!

I'm not directly affected, but I would like to make some kind of contribution.

I found this article[/url] in today's New York Times.

Steve Jones - Editor (1/14/2010)

---

Sad to see it leave the Olympics, but it's also not great that the US doesn't send it's best players. Nor do other countries that have...

Jan Van der Eecken (1/13/2010)

---

Yes, we do have a National Team. Went over to Spain for some large tournament and did relatively well. As to WBC? I really would not...

Lynn Pettis (1/12/2010)

---

ROFL When my dad moved out to Colorado from New Jersey in the mid 50's, relatives back there thought people still rode horses, carried pistols everywhere and...

Jan Van der Eecken (1/11/2010)

---

Great to see a Baseball Thread popping up on SSC!

I'm a big fan of the game, even if I happen to live in South Africa. Got...

Markus (1/12/2010)

---

The timing is interesting. I think it has more to do with him now being a coach for the Cardinals. He was going to be hounded by...

I'm not a Java programmer, either, so this is speculation on my part.

If I'm not mistaken, I believe Try-Catch is primarily a Microsoft SQL and .NET function. I'm guessing...

P Jones (1/12/2010)

---

The best articles I've found on vb.net are on http://www.4guysfromrolla.com especially those by Scott Mitchell and his data access series for Microsoft and all the other tutorials at...

Ah, yes. NextResult does sound familiar. Glad you got it working!

Monday

Sounds like "mundane."

"Just another manic Monday . . . "

mick burden (1/11/2010)

---

Hi everyone, I normally use VB6 as my programming language to read and write to a SQL server (2000), I've recently gone over to VB.Net (2008), my problem...