Show aggregate result and decimal numbers

Remko1981

Super that you added 'Show aggregate result'! 

Though on my machine it show the wrong numbers when using decimal numbers. See the attched screenshot.

cperez

Good Morning Remko,

Thanks for reaching out to Redgate Software, glad you are enjoying the new 'Show aggregate feature' feature, could I kindly have yo elaborate a bit further on what exactly you are attempting to do in this instance?

Remko1981

I tried to make an example to show in the most basic way what is going wrong. So the value in the single cell is 2.1 . But when i click 'Show aggregate result' it gives a sum, average, min and max of 21 . It erases the decimal seperator. This also happens when you select multiple rows.

In the Netherlands we normally use the comma (,) for the decimal seperator. So maybe my regional settings in combination with SSMS messes things up. Excel for instance uses the regional settings correctly(a comma) but SSMS does not it insists on using a dot (.) for the seperator on decimal values.