I have a table with the following columns and data:
activity_dt | activity_amt
2009-01-01 | -500
2009-01-01 | 750
Can I write a query that looks at the sign of activity_amt and puts it in the credits column if it's positive, and the debits column if it's negative? (I'm using Sybase)
activity_dt | debits | credits
2009-01-01 | -500 | 750