Hi JonFox,

Thanks for the detailed explanation...will try to digest it and probably I'll modify the query.

Usman Butt (11/28/2011)

---

Sorry, but I am still not able to understand it. Should 2039 have to be concatenated, since it has a child 2041 now? Or you just want to...

Hi Usman Butt,

The output for the table is exactly the second table shown in my first post. Yes, I want to see the concatenation only for the leaf level childs.

Thanks.

Hi JonFox,

I attach the full query (.txt) and execution plan (.sqlplan) here. Thanks.

Hi JonFox,

What do you mean by the 'actual execution plan for the long running query'? Are you referring to the whole actual sql script that I'm executing?

* Please do not...

Hi JonFox and other SQL Gurus,

After I had done some serious testing on recursive CTE, I found out that my report performance is quite bad when I switch from one...

I am not using SSIS or SSRS either. I am using a BI tool from Infor...not sure you guys have heard of that before. Currently, all my reports are generated...

Hi JonFox,

Thanks for the detailed reply...really appreciate it. This is not a homework question. I am currently working in a BI project and users want to drill a report to...

Hi Lowell,

Join the table might be an option but the joined results shown by you is not quite correct.

--Results--

organization account interco currency amount organization account interco currency amount

------------ ------- -------...

Florian Reischl (9/11/2011)

---

Hi

Huh? ColdCoffee's is correct in my opinion. The result returns all...

ColdCoffee (9/11/2011)

---

This?

SELECT * , NEWRATE = t1.AMOUNT * t2.VALUE

from [Fact table] t1

inner join [Exchange Rate table] t2

on t1.CURRENCY = t2.FOREIGN_CURR

...

dogramone (9/8/2011)

---

I would do this one with the tool that is displaying the data as they ususally have much better format masking. Remember a database is for managing data...

Thanks alot opc.three. Appreciate it!

Hi sivaj2k and LutzM,

Thanks for the different solution...had tested and both works like a charm...now i know which part had gone wrong.

Phil Parkin (4/17/2010)

---

There is a better way of doing this which does not require a lookup table.

Add a derived column which converts NULLs to "No_Product_Line" and leaves non-NULL data as...