something along the lines of

edit your duplicate posts

delete content and replace with something like this.....

"duplicate thread please post all replies to <insert URL here>" where URL is the single...

no need to cross post...please select one thread and repoint all others to just the one.

thanks

Have you...

Zidar (7/8/2016)

---

Obviously, we need more constraints. What we have so far is OK, but we need more. Time permitting, new post is coming this afternoon, if not, then on Monday...

edit...the original OP...

The Dixie Flatline (7/6/2016)

---

Already did that. The extraction query itself takes about 15 seconds on my box. Execution plan says 30% of that is just...

yeah.. I think it works...sorry but havent had time...

The Dixie Flatline (7/6/2016)

---

Hey JLS, I think I have a solution, but for some strange reason the website won't let me post or upload the code if I spell out...

J Livingston SQL (7/5/2016)

---

Hi Alan..have been following your recent scripts and am suitably impressed.

its now

bed o'clock here and busy tomorrow...but hoping I can work through and understand your...

does this work for you?

CREATE TABLE #testtable(

ID INT NULL

,Code VARCHAR(6)...

ok so you will need to exclude all 'jls' rows from the...

so, are you ever going to have a...

does this help you get going?

CREATE TABLE tab1(

Product VARCHAR(1) NOT NULL

,Currency VARCHAR(3) NOT NULL

,Cost INTEGER ...

amanspschauhan (7/5/2016)

---

I have tried this-

select

Table 1.Product,

Table 1.Currency,

Table 1.Cost,

Case

when Table 2.Currency in ('AUD','CAD','EUR','GBP','INR','PLN','USD')

then (Table 1.Cost/Table 2.ConversionRate) End as Actual Cost

From Table 1, Table 2

but it is giving me 56 records...

what have you tried so far?

hint> create a join between your tables based on "currency"