Thanks very much for your helpful solution, Phil....I really appreciate it. You have also cleared my long running confusion about this !!

Hi Phil,

Thanks for your reply. What I need to achieve is SUM of GROSS_WGT and then GROUP BY BOOKING_ID. The query below would give you the clear picture:

SELECT

...

Thanks a lot for your help, Ron !!

Hello Tom,

Thanks a lot for your solution. It was really helpful...

Regards,

Paul

Hello Ron,

Thanks a lot for your reply. I have a query where I need to include the sum of rows per Booking ID. The data for all the columns -...

Hi Adi,

Thanks a lot for your reply. I had just one more query for you. How would you then sum the TEU which would be based on the rows per...

Hi ColdCoffee,

I am sorry this was my mistake...your query works fine even in the scenario when more than 10 case statements exist....I confused this with the nested case statements...sorry to...

Thanks a lot, ColdCoffee, that worked like a charm !!

Kind Regards,

Paul

Hi ColdCoffee,

Thanks a lot for your reply. However, when I ran your query I only get the max value(only 1) for each of the column. There are more than a...

resolved it...its working now....Thanks for your help...

just had to do this...

to_char(sysdate, 'YYYYMM')

Derrick Smith (1/25/2011)

---

Phil Parkin (1/25/2011)

---

Derrick Smith (1/25/2011)

---

I always try to keep my queries as SPs on the database itself, and then reference the SP from the package. Makes maintenance/troubleshooting much...

Hi Jeff,

Thanks for your reply..I am still stuck on this problem...dont know how to resolve this now....have tried everything and have really exhausted every option.

One more table has been added...

HI Jeff,

Sorry about the mistake in the DDL, I have corrected the same in my earlier post...it should be:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[NCV_BL_DHL_TEMP](

[BL_ID] [decimal](10, 0) NOT NULL,

[BL_NUM] [nvarchar](13)...

Hi Jeff,

Thanks for your reply and sorry about not providing the updated tables and sample data. Please find the same here:

First one is the DHL_TRADE_ASSIGNMENT table-

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

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE...

Hi Jeff,

Here is the updated scenario:

If POL_COUNTRY_CD or POD_COUNTRY_CD in NCV_BL_DHL_TEMP table begins with FR, then use POL_Location_CD / POD_Location_CD and join to MG_LOCATION table to identify continent. If continent...