Thanks Ten Centuries, exactly what I was looking for.

filter out all rows where the stock is SOLD AND the delivery date <> Date

If I do above, then rownumber 3 & 12 will be excluded. Don't want to exclude...

Below is the create and insert scripts

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TEST_SAMPLE]') AND type in (N'U'))

DROP TABLE [dbo].[TEST_SAMPLE]

GO

CREATE TABLE [dbo].[TEST_SAMPLE](

[NR] [varchar](9) NOT NULL,

[ControlNo] [float] NULL,

[LocationNo] [varchar](50)...

• This reply was modified 3 years, 8 months ago by  waldemar.