Does anyone know why, using SQLServer 2005

```
SELECT CONVERT(DECIMAL(30,15),146804871.212533)/CONVERT(DECIMAL (38,9),12499999.9999)
```

gives me 11.74438969709659,

but when I increase the decimal places on the denominator to 15, I get a less accurate answer:

```
SELECT CONVERT(DECIMAL(30,15),146804871.212533)/CONVERT(DECIMAL (38,15),12499999.9999)
```

give me 11.74438969

## Best Solution

For multiplication we simply add the number of decimal places in each argument together (using pen and paper) to work out output dec places.

But division just blows your head apart. I'm off to lie down now.

In SQL terms though, it's exactly as expected.

You can do the same math if follow this rule too, if you treat each number pair as