For others' reference: I figured it out. The SQLDataSource object was refreshing just fine. The problem was with the GridView object. I had to refresh that as...

To go see the Royals,...

Only a month until pitchers and catchers report! 🙂

Spring Training is right around the corner!

No, you should still be able to use @@error,...

lmu92 (1/15/2010)

---

Since FLOAT is an approximate-number data type, the character length may vary, therewith exceeding the VARCHAR(10) limit.

You need to get the value converted to a "known length".

Either one...

Update: I came up with a kludge solution where I only updated a ZIP with len(ZIP) = 5.

For my future refence: any thoughts to my initial post?

Jan Van der Eecken (1/15/2010)

---

Re WBC, what I meant with "I really wouldn't know" was that I'm not an official of the SA Baseball Union, so I have no idea...

I'll bet it was really painful for you to type this! 😀

greggoble2 (1/14/2010)

---

--first I grab all the ID's that have a status of 4

Select MessageID

From MessageQueue

Where MessageStatusID = 4

--Then I put the messageID's from the results of the above query into...

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...