Viewing post 1 (of 1 total)
use Round function with convert......
SELECT convert(DECIMAL(18,2),ROUND(amount,2,1)) FROM #temp
October 18, 2012 at 12:03 am
#1550299