kabaari (10/24/2012)
Below are my results:yield
94.4000000000000000
97.6000000000000000
98.4000000000000000
96.8000000000000000
Now, I need to get rid of the zeros and show dates.
You should do formatting on the front end.
But if you must do it here, an easy way is
CAST( yield AS decimal( 3,1))