SQL Rounding issues
-
Hello,
I have a report that I am reverse engineering. The percentage for a specific column is 52.80%, but in my result set I continue to get 53. It's obviously rounding the number. Does anyone have a quick script that can convert this whole number to 52.80? Here is what I have...
Any help would be appreciated.
round(cast(sum(COLUMNNAME) as float)*100,3)
Dave
-
I know it's a dupe, I wanted to post with the code.
-
Hey friends,
I have a hard deadline for today, can someone please help?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply