Oh okay, it's using XPATH standards. I hadn't realized before being that it was coming back in text format. It's clearer now.

Thank you again !

Bob

This is quite interesting, thank you.

I saw a slightly different solution without the VALUE function:

select (

STUFF(

(select N', ' + cols.COLUMN_NAME as [text()]

from Razor_3_Snapshot.INFORMATION_SCHEMA.COLUMNS cols Where cols.TABLE_NAME=...

thanks for that response. I will give it a try .

Hi Craig,

First I would say YES - a very short term block every few minutes is acceptable. I can't imagine it would be blocked more than even 2 seconds.

Secondly, in...

Hi Craig,

It's a sql job that schedules the order_strategy table rebuild.

i.e. order_strategy forces certain type of parent/child orders to "stick" together on the main order board. The parent is the...

Thank you for your response.

I have been considering changing the READ UNCOMMITTED TO READ COMMITTED (which I understand to be the Sql Server default).

I only put the UNCOMMITTED in this...

@tfifield - I'm not familiar with this approach, but I will certainly have a further look at synonyms, etc.

Thanks for your response !

Bob

Yes, good point Craig. I am not crazy about this idea of rebuiling order_strategy each time either. I just found that if I don't clear out those records (and there's...

Hi Craig - Thanks for your response.

The bad news is that my order_strategy table gets rebuilt by a Sql job every couple of minutes.

The good news is that I can...

Yes you pointed out something interesting : "status" column comes from order_fx . I suppose that should be qualfied with the "ord" alias to be consistent.

And yes, I would like...

my apologies, as I got distracted and posted before I actually asked the final question.

Note: my outer join is on table name "order_strategy", and I reference it using alias "s"....

So if I do qualify it as ord.mkt_rate, does this Select logic look good ?

And by the way, mkt_rate is in fact in my orders table.

Thanks,

Bob

Thanks for that idea, too.

Great idea! I have CASE statements in other areas of the query, so I don't know why I didn't try that before. Let's see if this makes sense...

Now I calculate...

Boy do I wish I could do that ! The problem is the type of currency order determines whether I pull the bid or ask value for that currency pair...