Hi guys,

Thanks for your responses. Unfortunately the query is for a system that won't be going Live till April. I'm expecting to get some historic data to popular...

Hi WayneS,

Thanks for your reply. I did try Row_Number but got the same message about window functions. What I didn't know was the WITH syntax, essentially is this...

Sure, here you go:

CREATE TABLE [BUDGETS](

[ACCOUNT_CODE] [varchar](25) NULL,

[SECONDARY_CODE] [varchar](25) NULL,

[RECORD_TYPE] [varchar](2) NULL,

[PERIOD] [tinyint] NULL,

[YEAR] [int] NULL,

[VALUE] [float] NULL,

[REVISION_NUMBER] [smallint] NULL)

INSERT INTO BUDGETS VALUES ('AB12345','12345','C',1,0,1000.00,0)

GO

INSERT INTO BUDGETS VALUES ('AB12345','12345','C',2,0,2000.00,0)

GO

INSERT INTO BUDGETS...