That's great, many thanks. tbl_BPMCutOffDate only ever has one date, also thanks for spotting the tidy up on the outer join.

Wow, completely different way of thinking... many thanks. Hopefully I'll start mastering the dark art 😀

Thanks for the response.

I don't use : WHERE tbl_BPMStockDelays.bCutOffDate = 1 as where bCutOffDate i want to retrieve a value to use as criteria in a where clause at row...

The table tbl_BPMHDR is really needed as it is only used for sorting by a field in that table :

tbl_BPMStockDelays :

CREATE TABLE [dbo].[tbl_BPMStockDelays](

[TimeStamp] [timestamp] NOT NULL,

[ExtractDate] [smalldatetime] NOT NULL CONSTRAINT...

Please find my code as below... please feel free to highlight any errors and any alternative approaches that could be taken.

ALTER PROCEDURE [dbo].[sp_BPMUpdateStkDlyOrd]

@QTY smallint = NULL

AS

BEGIN

SET NOCOUNT ON;

BEGIN TRANSACTION

--OUTER...

Hi, thanks for the replies so far... I'm now at home so my code isn't at hand but logically it's still in development and hence incomplete.

Basically i'm looping through future...