Hi All ,
I want always one decimal place number
cast(convert(DECIMAL(10,2), 10.100)as numeric(36,1))
This syntax giving correct output if value is in decimal it is rounding to 10.1
but if It is numeric then
cast(convert(DECIMAL(10,2), 10)as numeric(36,1))
It is showing 10 only but I want 10.0
How I can do that
Regards,
Vishal Bedre
Go to the complete details ...