I know that formatting numbers is a client-side task, but I have a special situation where I need to format a number in derived table using T-SQL.
I need -11812.53000 to appear like this: (11,812)
1) No decimal points (need to round up to the nearest dollar)
2) Commas for the thousands separator
3) Parentheses around negative numbers
4) The field *must* be numeric (can't be a string)
Again, I KNOW this isn't the proper way to use t-sql but I have to in this situation.