lax.rawat07 (11/10/2010)
i have a result setLedgerId, ProfitAndLoss
46 -3000.00
49 -7000.00
45 15000.00
I want Result Set As
LedgerId, ProfitAndLoss Result
46 -3000.00 Credit
49 -7000.00 Credit
45 15000.00 Debit
Please help me ProfitAndLoss Is a Decimal field and we have to separated by minus value
you can try using your 3rd column as a computed column.
if Profitandloss < 0 then 'Credit' ELSE 'Debit'
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle