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...