Thanks, I'll see if the CTE makes a difference. I will post the execution plans when I get a chance. Don't have direct access to the server a.t.m

The data table, Stock.Register:

CREATE TABLE [Stock].[Register](

[id] [int] IDENTITY(1,1) NOT NULL,

[Stock_Product_id] [int] NOT NULL,

[Stock_Status_id] [int] NOT NULL,

[Company_Supplier_id] [int] NOT NULL,

[Description] [nvarchar](200) NOT NULL,

[ReelNumber] [nvarchar](50) NOT NULL,

[Quantity] [decimal](10, 4) NOT NULL,

[Length] [decimal](10,...