Hey,

sorry for the format of the original post. I actually managed to solve it pretty soon after posting. I just had a few moments where I couldn't think. I used...

the solution worked. Many thanks

thanks a lot. that worked perfectly.

oh ok. i see what you mean. i will try this out and let you know how it goes. cheers

f00 represents an amount. H_EE and H_EY are entities which the f00 is split between. The d_ent is meant to be the new field which holds the name of the...

the data comes in a csv format. I have no lookup tables. I just have the one file.

Many thanks. That seems to work. much appreciated

Thanks a lot. I totally forgot about the EXCEPT statement. That worked fine. much appreciated

Thanks a lot. That seems to have done trick.

Oh ok that makes now. cheers

ok, but in my real example the entities are not in alphabetical order.

calvo (6/9/2011)

---

Took me a second to understand it too.

I believe the logic is, if there is one and only one entity for the RU, then show it. (adhering to your...

Using max and min seems to work. However I must admit I am a little unclear with the logic. Could you explain please.

Many thanks. The CTE option worked like a treat.

Many thanks for that. Will let you know how i get on.