L' Eomot Inversé (1/5/2012)
As far as I know there is no Connect bug report, and I don't think there's much point in raising one as it's clearly "by design"
Agreed.
I'm tempted to raise a connect item asking for support for the 2008 revision of the IEE floating point standard, including exponents to base 10 and 128 bit forms. That seems the obvious way to go in the long term. I looked a while back to see if there was a connect item for that and didn't spot one. An improved decimal type might be more likely to see a positive response in the short to medium term, but isn't as good a solution.
IIRC that's the same implementation used by the .NET framework. It would make a good Connect suggestion anyway. If you do enter one, link back here and I'll vote for sure.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi