Thanks for your help Jason.

Regards, Shuja

I think i might have found the solution after fiddling with Jason's original solution.

I've added a COALESCE to the DIRECTORATE_CODE at both end s of the case statement so...

Hi Jason,

I tried your solution but i get the same record count and the null value records aren't showing.

I also tried to enclose the DIRECTORATE_CODE in wildcards ('%' + DIRCETORATE_CODE...

Hi,

The reason i need to use an SSIS package is that this process i want to run is part of a monthly download which is done through an application called...

I've managed to find a possible solution using cross joins. See the following thread for more detail:

http://www.dbforums.com/microsoft-sql-server/1641161-show-all-records-one-table-each-record-another-table.html

thanks for your help.

Shuja