Hi

Here's another way using Jeff's data (thanks Jeff)

-- collect only the rows we're interested in

SELECT IDENTITY (int, 1, 1) AS RowID, *, CAST(0 AS int)...

Hi Chris

This should do the trick.

CREATE TABLE #MSG369550 (AccountDate DATETIME, parent CHAR(6), RecordCode CHAR(11), AccountName CHAR(5), Quantity INT)

INSERT INTO #MSG369550 VALUES ('12/31/2002','PARENT','RECORDCODE1','ACCT1',10000)

INSERT INTO #MSG369550 VALUES ('01/31/2003','PARENT','RECORDCODE1','ACCT1',12000)

INSERT...