I think that some things should be pointed out here, lest someone reading these posts gets the wrong idea...

First, there is no such thing as an "MSDN MVP" it's just...

GilaMonster (3/6/2009)

---

Something occurred to me...

How much of that came about because...

Grant Fritchey (3/4/2009)

---

GilaMonster (3/4/2009)

---

Derek Dongray (3/4/2009)

---

The items I did find suspect were from reading his blog, in particular a list of SQL query performance tips with no explanation as to...

GilaMonster (3/4/2009)

---

Derek Dongray (3/4/2009)

---

The items I did find suspect were from reading his blog, in particular a list of SQL query performance tips with no explanation as to why any...

Grant Fritchey (3/4/2009)

---

Lynn Pettis (3/4/2009)

---

QUESTION!!...

You know this is the most amazing part to me, how can an...

Try wrapping it in a SQL Stored Procedure.

I am not sure if that is necessary, but I am pretty sure that it will work.

Aha! The true culprit has finally revealed himself! 😀

(seriously though, that's probably my favorite line in this entire thread, Michael)

Gail: Oops, I missed the last "x"! ...

Lynn: Thanks, but as Gail pointed out, I was not entirely correct.

Edit: Said "was", should have said "was not". slight difference......

Hmm, I think it's this:

CASE x

When 'YEN' Then 'JPY'

When 'EURO' Then 'EUR'

End AS InvCurr

Thanks Brian, I think that worked! 🙂

I have an example of how to do this in my code Camp Presentation Kit "The Top 10 Reasons You Aren't Already Using Service Broker" at my blog site, here.

ProcessAdmin should work.

You will have to supply much more specific information about you data and the feeds, before you will get an answer of any value.

Reasonman (3/1/2009)

---

However, this is not an easy task. It can't even be done from ADO. Therefore, I am trying to gauge the interest in developing a marketable COM...