Thanks for all the responses and sorry for replying back so late. Matt's rewrite seemed to help speed things up, thanks Matt.

Brgrds Priya

Hi, thnx for the quick responses, here are the create table DDLs:

CREATE TABLE [dbo].[Pl_All_Sales_Deleted]([Country] [char](15) NULL,

[Year] [int] NULL,[Month] [int] NULL,[AccountNo] [char](15) NULL,

[ProductCode] [char](25) NULL,[ProductName] [char](100) NULL,

[Margin] [decimal](11, 2) NULL,[Volume] [int]...

H

i sorry for being a bit ambiguous, the query takes to long to run so I was looking for another way of rewriting the query to make it faster.

Thnks Priya