I am novice in sql server 2000.
My test table have this columns with this data
cus_id inv_n date_ip debit credit
1 101 10.01.07 100.00
1 101 25.01.07 70.00
1 101 26.01.07 10.00
2 102 11.01.07 200.00
2 102 26.01.07 150.00
2 103 27.01.07 300.00
How can I got with query this resulsts
cus_id inv_n date_ip debit credit total
1 101 10.01.07 100.00 100.00
1 101 25.01.07 70.00 30.00
1 101 26.01.07 10.00 20.00
2 102 11.01.07 200.00 200.00
2 102 26.01.07 150.00 50.00
2 103 27.01.07 300.00 350.00
My test table have this columns with this data
cus_id inv_n date_ip debit credit
1 101 10.01.07 100.00
1 101 25.01.07 70.00
1 101 26.01.07 10.00
2 102 11.01.07 200.00
2 102 26.01.07 150.00
2 103 27.01.07 300.00
How can I got with query this resulsts
cus_id inv_n date_ip debit credit total
1 101 10.01.07 100.00 100.00
1 101 25.01.07 70.00 30.00
1 101 26.01.07 10.00 20.00
2 102 11.01.07 200.00 200.00
2 102 26.01.07 150.00 50.00
2 103 27.01.07 300.00 350.00