Multiply Rows with T - SQL

Multiply Rows with T - SQL

• tcsss

  Uwe,
  
  LOG is the natural logarithm function in SQL Server.
  Also, see some of the previous discussions of this question:
  http://groups.google.com/groups/search q=aggregate+product+kass+sqlserver
  
  Steve Kass
  Drew University
  
  Uwe Helmer@discussions.microsoft.com wrote:
  
  > I need to multiply rows of a table with each other. I found a function
  > like this
  > 
  > exp(sum(ln(floatfield1))).
  > 
  > But I can not find the ln function. Is there any other possibility  
  > 
  > 
  > 
  > Thanks for any help.
  > 
  > Uwe
  > 
  > 
  

  
  

• Bikaram

  In your SQL statment

  exp(sum(LOG(floatfield1))).

  In SQL

  Constant e (2.71828182845905…) based Natural log is set as LOG and 10 based is written as LOG10.

  Some examples:

  LOG ( e ) = 1.0

  EXP( LOG( n ) ) = n.

  10 ^ LOG10(n) = n

  This seelect statement

  SELECT LOG (EXP (5))

  returns 5.

  
  

• Kemp Brown MSFT

  in function is this for MS SQL Server
  
  Post your table structure, some sample data and the expected result. We should be able to help you to come up with the query
  
  
  
• Multiply Rows with T - SQL