How to manage exponents from mining output

• patrick.w.wheeler

  SSCommitted

  Points: 1796

  More actions

  August 24, 2016 at 9:39 am

  #320910

  SELECT FLATTENED

  [UI] AS [UI.CODE], 100 AS [PARTICIPANT.ID], 'TOTAL' AS [UNIT.TYP], 'UNITS' AS [FCST.TYP], 'FCST' AS [FCST.VERSION]

  ,

  (

  SELECT

  $TIME AS [QUARTER]

  ,[TOTAL UNITS] AS [VALUE]

  ,PREDICTVARIANCE([TOTAL UNITS])AS [VARIANCE]

  ,PREDICTSTDEV([TOTAL UNITS]) AS [STDEV]

  FROM

  PredictTimeSeries([TOTAL_UNITS_FCST].[TOTAL UNITS], 4) AS t

  ) AS FCST

  FROM

  [TOTAL_UNITS_FCST]

  Do any of you know a way to control exponents notation from the output of a function, such as Predict var and dev, even the time series prediction. From my database / view numbers are set to decimal (38,9). None of them display as an exponent notation.

  Thanks

  Querying Microsoft SQL Server 2012/2014 - Certified

• patrick.w.wheeler

  SSCommitted

  Points: 1796

  More actions

  August 24, 2016 at 10:29 am

  #1897250

  I'm going to rebuild my table and go to float data type.

  Love rebuilding my MODELS, all 6 of them. :/

  Querying Microsoft SQL Server 2012/2014 - Certified