Thank you for your reply. I am bringing in the raw value and calculating the average of those raw value in the matrix by group. So i am using avg...

Thank you. Works like a charm.

But I really need serious help on this.

I am sorry but I did not know. I can take it out.

Good Afternoon Lowell,

Here is the DDL. Please help. Thank you.

---For current balance

CREATE TABLE #Display

(

acct_no int,

acct_type char(3),

effective_dt datetime,

cur_bal decimal(18,2)

)

INSERT INTO #Display

(

acct_no,

acct_type,

effective_dt,

cur_bal

)

(

SELECT '112233' as...

Thank you. Can I send you a DDL and may be you can help. Please let me know.

Thank you for the reply. But the cur balance is in one table and the transaction is in another. I would have to use cur balance and remember the previous...

Got it working thank you.

Thank you for the reply. But my mistake. I put No to specify what rows i want to be taken out from the result.