Sql Problem
-
Id Credit Debit CurrentCredit Current Debit 51 21500 0 21500 0 52 0 21500 0 0 89 0 2150 0 2150 93 0 2140 0 4290 128 2140.5 0 0 2149.5 129 2151.5 0 2 0 171 0 1628 0 1626 190 1628 0 2 0 i have column of credit and debit and want to get columns of current credit and current debit example: 51. credit=21500 and debit=0 i have credit more than debit so this increase credit and decrease debit then current credit = 0+21500 52. credit=0 and debit=21500 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit =0 89 credit=0 and debit =2150 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=0+2150=2150 93 credit=0 and debit =2140 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=2140+2150= 4290 and so on...
-
Id Credit Debit CurrentCredit Current Debit 51 21500 0 21500 0 52 0 21500 0 0 89 0 2150 0 2150 93 0 2140 0 4290 128 2140.5 0 0 2149.5 129 2151.5 0 2 0 171 0 1628 0 1626 190 1628 0 2 0 i have column of credit and debit and want to get columns of current credit and current debit example: 51. credit=21500 and debit=0 i have credit more than debit so this increase credit and decrease debit then current credit = 0+21500 52. credit=0 and debit=21500 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit =0 89 credit=0 and debit =2150 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=0+2150=2150 93 credit=0 and debit =2140 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=2140+2150= 4290 and so on...
That's very interesting. Is there a question in there?
-
Id Credit Debit CurrentCredit Current Debit 51 21500 0 21500 0 52 0 21500 0 0 89 0 2150 0 2150 93 0 2140 0 4290 128 2140.5 0 0 2149.5 129 2151.5 0 2 0 171 0 1628 0 1626 190 1628 0 2 0 i have column of credit and debit and want to get columns of current credit and current debit example: 51. credit=21500 and debit=0 i have credit more than debit so this increase credit and decrease debit then current credit = 0+21500 52. credit=0 and debit=21500 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit =0 89 credit=0 and debit =2150 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=0+2150=2150 93 credit=0 and debit =2140 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=2140+2150= 4290 and so on...
-
Id Credit Debit CurrentCredit Current Debit 51 21500 0 21500 0 52 0 21500 0 0 89 0 2150 0 2150 93 0 2140 0 4290 128 2140.5 0 0 2149.5 129 2151.5 0 2 0 171 0 1628 0 1626 190 1628 0 2 0 i have column of credit and debit and want to get columns of current credit and current debit example: 51. credit=21500 and debit=0 i have credit more than debit so this increase credit and decrease debit then current credit = 0+21500 52. credit=0 and debit=21500 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit =0 89 credit=0 and debit =2150 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=0+2150=2150 93 credit=0 and debit =2140 i have debit more than credit so this decrease credit and increase debit then current credit =0 and current debit=2140+2150= 4290 and so on...
As interesting as your data is, what is your query?
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering