Maybe I'll just stick with my new idea which appears to be working :

Select distinct

dbo.get_mkt_rate(ord.cur_1,ord.cur_2,ord.order_type, ord.buy_cur, @fxo_bidask) mkt_rate,

ord.cur_1,ord.cur_2,ord.order_type, ord.buy_cur

...

"Rename one of both columns and you'll be fine. (for the column names ...)"

Actually I can't. If I rename this :

Select NestedSel.*,

mkt_rate =...

Actually I was initially embedding the call to get_mkt_rate() in my query in three places, but I run the risk of getting back more than one unique value by doing...

Hi again,

Regarding the embedded qry you suggested recently, I'm getting an error when I execute my procedure in a Sql Query window:

"Column names in each...

thank you.

Actually, I'm now experimenting with calling the function mult. times as suggested by the gentlemen earlier:

Select ord.amount,

ord.amt_unit,

...

"Why can't you design the database such that the market rate is just a join to another table? Then you don't have to do the lookup function."

It's because the client...

Thank you for your response. My problem is that I cannot call get_mkt_rate() multiple times because the market rates are moving much too fast. Sometimes I'll get slightly different mkt_rate...

good point. I've tried that in the past but perhaps I will revisit that idea.

Thanks for your response.

Have a great day.

bob

Thanks for confirming that.

In my case, I need READ UNCOMMITTED when the client app refreshes the display of data. The refresh rate on our client is about 4 seconds, so...

Bingo! I have a trigger on that Order_fx table.

But I don't understand your comment "...two locks taken on one of the connections".

I changed sql 2005 to listen on port 5000 as a test and kept sql 2k on port 1433. I'm still having the problem.

How do I tell if listening on...

Inh Sql Svr Config Mngr, TCP is in fact enabled. However, when I bring up Surface Are Config I get a nasty error saying "No Sql 2005 components found. Either...

Hello Michael,

 Regarding your previous response:

"Then, you have a couple of IF statements and logical IF's are not too speedy either.  This could have all been done with set-based updates and...

Yes Michael. I do realize what you mean about the mult table updates. I actually dealt with something like that some time ago and you folks on this forum helped...