MVSFORUMS.com

[psridhar]

Can anybody help me in achieving the resultant table as follows.

My main table contains the columns as follows.

[code:1:181fa4cca1]
----------------------------------------------------------------------
Month Year Customer Id Fee Type Fee Amount
----------------------------------------------------------------------
12 2004 C1 AAAA 100.00
12 2004 C1 BBBB 70.00
12 2004 C2 AAAA 30.00
12 2004 C2 CCCC 50.00
12 2004 C3 AAAA 55.00
12 2004 C3 BBBB 75.00
01 2005 C2 AAAA 65.00
01 2005 C3 AAAA 45.00
01 2005 C3 BBBB 55.00
01 2005 C4 AAAA 25.00
01 2005 C4 CCCC 35.00
----------------------------------------------------------------------

Say the fee paid in 12-2004 as Previous Sum and in 01-2005 as Current Sum.

My resultant table should be as follows.

-------------------------------------------------------
Customer Id Current Sum Previous Sum

[kolusu]

Psridhar,

What is the column definitions of Month, YR and amount fields?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[kolusu]

Psridhar,

Assuming that your column definitions for month and year are integers, the following query will give you the desired results.

[psridhar]

Hi Kolusu

Thank you very much..... With some slight modifications to your SQL, I could able to achieve my requirement. Thanks for the suggessions.

Thanks
Sridhar