error

• hbtkp

  SSCommitted

  Points: 1731

  More actions

  April 11, 2012 at 8:30 am

  #267161

  hi

  exp(sum(log(CASE WHEN field = 0.0 THEN 1 WHEN field IS NULL THEN 1 WHEN field= -100 THEN 1 ELSE 1+field/100.0 END )) )-1.0)* 100

  i am using this expression in my query, getting error

  Msg 8115, Level 16, State 2, Procedure pPortfolioDashboard, Line 166

  Arithmetic overflow error converting expression to data type float.

  any idea?

• drew.allen

  SSC Guru

  Points: 76984

  More actions

  April 11, 2012 at 9:05 am

  #1471936

  Please do not create duplicate posts for the same topic. It fragments the replies. Please respond in this thread. http://www.sqlservercentral.com/Forums/Topic1281038-392-1.aspx

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  April 11, 2012 at 9:25 am

  #1471967

  drew.allen (4/11/2012)

  ---

  Please do not create duplicate posts for the same topic. It fragments the replies. Please respond in this thread. http://www.sqlservercentral.com/Forums/Topic1281038-392-1.aspx

  Drew

  Beat me to it.:cool:

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events