I am having a problem with percision which appears to be a documented bug is there a work around

I have been working on an application which require as much percision as we can get. We have defined all numeric values as (38,16) however when ever we divide a number by the result of a built in function it truncate the percision to 5 decimal place this cause us to have a small but enoying loss in the numbers being caculated we need a minimuim of 8 decimal places or better is there a work around or solution for this problem in sql server 2005. The more percision the better.

example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345

the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = .00000

if it is a reporducable bug use the product feedback center to report the bug:

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220

Otherwise you can use the SQL Server Data Access forum to ask your question

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

|||

Hi Caverman1,

It isn't bug. I resolve this issue in other thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=661591&SiteID=1

Good coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/