Tuesday, 01 May 2007
SQL: format numeric to x decimal places
i found this was very hard to figure out. i read lots of approaches to hack the data into char(5) etc to give you "23.54" using Round() etc. but that seemed messy. the key is to cast to type Numeric(size, decimalPlaces). for example:
CONVERT(Numeric(10,2), (Count(ID) * 100. / @Total)) as Percentage
the above will display "23.54" (for example), including rounding, as a number.
Tuesday, 01 May 2007 12:53:15 (GMT Daylight Time, UTC+01:00) Database