Hi Craig,

Could you please suggest something else as the code you mentioned does not yield the correct resultset ?

I am still stuck at the moment and have already tried different...

Hi Jeff,

Thanks for your reply. What I want to know is how can I change the format of the date on the SSRS matrix report. I wish to display months...

Hi LutzM,

The issue is to include a new condition in the query that has already been created.

The condition is if value in POL_COUNTRY_CD or POD_COUNTRY_CD column in table NCV_BL_DHL_TEMP...

Hi Lutz,

I really have no answer to your questions and am stuck with no option but to resign from my current position here.

I actually made a bad choice when I...

Hi Craig,

The condition is if POL_COUNTRY_CD or POD_COUNTRY_CD in table NCV_BL_DHL_TEMP begins with FR, then would need to join to MG_LOCATION to identify continent.

If continent is equal to 'EUR' then...

Hello LutzM and Jeff,

Thanks a lot for your replies. One thing I forgot to mention is that this project is part of an SSIS package. If you are familar...

Hi Craig,

Thanks for your reply. The NCV_BL_DHL_TEMP table will be joined to MG_Location on

NCV_BL_DHL_TEMP.POL_COUNTRY_CD = MG_Location.COUNTRY_CD

Hope that helps.

Kind Regards,

Paul

Hi Jeff,

Thanks a lot for your reply. Please pardon me for the lengthy message below-

What I am trying to do is trying to modify a query based on changes in...

Hi,

Thanks for your reply. I think I am not able to explain my question. I wish to display the name of months- January, February, March etc in the matrix...

Hi GSquared,

Thanks for your reply. What I am trying to do is join two tables to display columns(5 in total) from both the tables and populate it in a resulting...

Hi Craig,

Thanks for your reply. Is it possible for you to give some hint into this ? I am struggling with this for a long time now.

Kind Regards,

Paul

Hi Daniel,

Thanks for your reply. However, I did not understand your soluton, could you please elaborate on what you have mentioned ?

Hi Steve,

Thanks for your reply. However, I am very new to SQL and SSIS socould you please elaborate on what you mentioned ?

Kind Regards,

Paul

Hi Harinerella,

Thanks for your reply. However, I dont know what you mean by CTE ?

Hi Craig,

Thanks a lot again for your solution. However, I am getting duplicate values now not due to your code but due to the other piece of code thats already...