I'm attempting to include a few currency numbers in my results, but they are returning ridiculously long decimals, so I'm trying to round to 2 decimals and drop the 0s behind that. I've tried different versions of ROUND, CAST, TRUNCATE, and DECLARE but without much success. Here's the SELECT statement I started with, along with the results. Any ideas about how to resolve this would be appreciated!
SELECT account.accountnumber, account.name, ROUND(SUM(ordertcb.value), 2) booked, ROUND(SUM(invoice.amount), 2) billed, ROUND(account.balance, 2) balance
... View more