Numeric multiplication scale problem

• AnzioBake

  SSCarpal Tunnel

  Points: 4134

  More actions

  February 7, 2005 at 7:21 am

  #84695

  Multiplying two Decimal( 38, 21 ) variables I am getting what appears to be a decimal( x, 6 )  as a result( see below).  I need the higher precision, any Ideas???

  Declare @P Decimal( 38, 21 )

    ,@I decimal(38, 21)

  Set @p = 499999.798513

  Set @i = 1.00 / 1000000

   

  Select @p * @i

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 7, 2005 at 2:25 pm

  #541024

  See if this helps:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=155613

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• AnzioBake

  SSCarpal Tunnel

  Points: 4134

  More actions

  February 7, 2005 at 11:39 pm

  #541065

  Thanks Frank. 

  This did help, except for the numbers and precision I am using, but now i can work around the situation.