SQL Server: How do I truncate (not round) decimal places?
I am writing a stored procedure in SQL Server 2008 R2.
I am struggling with rounding / truncating a decimal value.
For example the value 9.567 gets rounded up to 9.57, but that is not what I need.
In my situation I just need to truncate (chop off) the last digit. The desirable value is 9.56.
How do I do this?
Craig Johnston, Feb 23, 2013
You can create this as a function and call any where in the your stored procedure
Yogesh Rajput, Sep 05, 2013