Thx once again Jason.

Thx Jason for such a sqift response. It works as expected.

I still ahve a question though, will it work when there are missng records on either tables, ie,

You may sell...

Thx Jason,

and Sorry to allif there was some confusion. I do not need to calculate the Forecast accuracy

(ie, Absolute(Shipped_Qty - FC_Qty)/FC_Qty ) at this stage. I just...

Hi Gianluca and All,

I have used the FULL join but resulta are not as expected.

Here are the sql for testing.

------Table #T1 (InvoiceLinesMonthly)

CREATE TABLE [dbo].[#T1](

[Customer_Group] [char](20) NULL,

[Stock_Code] [char](16) NOT NULL,

[Whse_Code]...

Thx for the Help guys.

I used the file - temp-table - real-table approach.

ddmmyyyy field was defined as a char(8) on the temp-table. All the fields from the flat file were...

I am using DTS Import. Thx.

Thanks to everyone who put in their methods.

This is what I came up with:

[font="Courier New"]CREATE FUNCTION [dbo].[ufn_GetYYYYMMSixMonthsAgo_YYYYMM]

( @pYYYYMM int )

RETURNS int

AS

BEGIN

Declare @Mth char(2)

Declare @Yr char(4)

Declare @NewYYYYMM char...

Those are Warehouse Codes; So I need the 6MthQy Column by Whse_Code.