Hello Craig,

Thanks a lot for your quick answer !! Your code is absolutely correct and I am not getting any duplicates now.

The problem I am now have is...

Thanks again Rashmi....it really feels awkward to ask you everytime now as you must also be busy at your work as well. Actually I am not an expert at SQL...

Hi Phil,

Thanks a lot for your reply. The DHL_TEMP table would include the value for the Tradelane per BL_ID. Please find the table structure for the DHL_TEMP table below:

-----------------------------------------------------------

SET ANSI_NULLS...

Now before you teach me some sql code posting...

Hi Wayne,

Thanks a lot for your suggestions. The question I want to ask is-

I need to assign a value to a column called 'tradelane' for each unique BL_ID...

What format do you want me to convert the spreadsheets then ?

I have attached all the relevant documents which are being used for this query. Would that be enough ?

Hi LutzM,

What exactly do you need from my side to resolve this issue ?

What I am trying to do is to populate a newly created column called Tradelane based...

Thanks a lot for your answer Rashmi, but now I am stuck with 15 nested case statements (and increasing) which exceed the total 10 allowed in SQL....as there is a...

I tried my best to explain the problem in short and in detail as well. Rashmi was able to understand it the first time when I posted it and she...

Hi Rashmi,

I cant really thank you enough. You have really made my day today....I had asked this many times now and each time I got back the reply that my...

Hi LutzM,

I don't know what I am missing here. Can I just show you an example of what I am trying to do:

This is the table based on which I...

Actually it is part of the formatting of this message as they go all jumbled up without the dashes....

you may be right but the thing is I also have to...

Thanks for your consideration....here is the detailed version of what I am trying to do-

-------------------------------------------------------------------------------------------------

I need to assign a value to a column called 'tradelane' for each unique BL_ID in...

Okay guys, No worries..thanks for your suggestions...I guess I have to go about it on my own..