SqlDbx
You are not logged in.
Pages: 1
How come CONVERT(DECIMAL(10,2),Amount) AS [Sales Type 1] is still showing as ### instead of ###.##?
Offline
What type is amount? Does it has fractional portion?
If amount is integer and Results Options ->Truncate trailing zeroes is on than display format will be ###
otherwise it should be ###.##
Offline
Sorry for the delay...the trim trailing zeroes was checked. Unchecking it fixed the problem. Thanks!
Offline
Pages: 1