>>>>CREATE TABLE Register >>>> (RecordId INT IDENTITY PRIMARY KEY NOT NULL, >>>> Sequence INT NOT NULL, >>>> Date DATETIME NOT NULL, >>>> TransType VARCHAR(5) NOT NULL, >>>> TransDesc VARCHAR(MAX) NOT NULL, >>>> Memo VARCHAR(MAX) NULL, >>>> Payment MONEY NULL, >>>> Deposit MONEY NULL, >>>> Reconciled BIT NULL) >>>>>>>>
>>>>SELECT SUM(Deposit + Payment) AS Balance FROM Register GROUP BY Sequence ORDER BY Sequence >>>>>>>>
>select Register.*, Balance from Register INNER JOIN >(SELECT Sequence, SUM(ISNULL(Deposit,0) + ISNULL(Payment,0)) AS Balance >FROM Register GROUP BY Sequence) B on Register.Sequence = B.SequenceI'm not sure if I'm explaing what I want. This query does not return the results I want:
Payment Deposit Reconciled Balance --------------------- --------------------- ---------- ------------ NULL 750.00 NULL 750.00 18.52 NULL NULL 18.52 74.28 NULL NULL 74.28 42.16 NULL NULL 42.16 100.00 NULL NULL 100.00 NULL 150.00 NULL 150.00 112.25 NULL NULL 112.25The last column should be have the balance, not the value of the despoit or payment column.