I want the 2 compute column to show only 4 decimal, but I cant find a way to affect the return value of 'em.
I wrote down this command "compute avg(x)" because I need the average to be in a seperate table.
When you use compute avg(x) here x is cast (price as decimal(10,4)) because I need the price to show up in the main table, and I need it with 4 decimals.
So I need a way to cast the return...
thierry savard
Last Activity: Feb 2 '11, 05:41 PM
Joined: Jan 26 '11
Location:
-
thierry savard started a topic Is it possible to cast the return value of a compute avg(X value) to show 4 decimal?in SQL ServerIs it possible to cast the return value of a compute avg(X value) to show 4 decimal?
Last edited by Niheel; Jan 26 '11, 08:14 PM.
No activity results to display