Lol I'm sure he could!

No that would be Joe Celko .

yes please!!!!!

That was the whole point .  So that makes me right and sain again. .

That's it, now you'll have to tell us what it is .

You may think you are right.  But I also think I am so that makes me normally affected I guess.

Try not enough time .

I'm still modest.  Saying that I have 7K + posts is not showing off when it's actually true and in front of the whole world to see !!!

You can always download the page to your hd, then parse it to find the current exchange rate and update a table on the server which fires a trigger that...

There is the triangular join way but the temp table will always be faster for larget data sets.  So use David's solution.

Try finding another poster with 7K posts to his count.  There are only 2 more on this site.  As for the ninja part it was decided in PM with me...

Ya but you can't join using a column as a parameter (unless you use sql 2005 where the cross apply operator becomes your friend

Well switched might be an overstatement.  I have to make this application compatible with 2000 as well.  So we basically design it for 2000 and retest on 2005 (at least...

Seems ok on a fast read.  What error are you getting?

BTW, it would be easier to read if you were using the inner join syntax.