Hello, is there a way to convert the value to just 2 decimal places, I created the report in Reporting Services and it has quite a few digits to each value. I looked at the table and found that the data type is {Float}. Is there a way to convert the values to just 2 decimal places?..Thank You.
Try this...
Code Snippet
select cast(columnName as numeric(10,2)) as 'columnName' from tableName
|||That worked, Thank You...
No comments:
Post a Comment