Script to calculate Precision & Scale of a Decimal Value

• Lonely Rogue

  SSCrazy

  Points: 2578

  More actions

  June 5, 2012 at 1:14 pm

  #392438

  Comments posted to this topic are about the item Script to calculate Precision & Scale of a Decimal Value

  --In 'thoughts'...
  Lonely Rogue

• Sreepathi1987

  Default port

  Points: 1425

  More actions

  June 19, 2012 at 6:54 am

  #1502795

  DECLARE @D DECIMAL(18,9)

  ,@S VARCHAR(20)

  ,@R VARCHAR(20)

  ,@Pos SMALLINT

  SET @D = 5.1235698

  SET @S = CAST(@D AS VARCHAR(20))

  SET @R = REVERSE(SUBSTRING(@S, CHARINDEX('.', @S) + 1, 20))

  SET @Pos = PATINDEX('%[1-9]%' , @R)

  IF @Pos = 0

  SELECT 0

  ELSE

  SELECT LEN(SUBSTRING(@R, @Pos, 20)) AS Length

• Lonely Rogue

  SSCrazy

  Points: 2578

  More actions

  June 22, 2012 at 10:35 am

  #1504624

  That is true.. your script evaluates in the same way as mine does. As noted, there exists many approaches that includes yours.

  However, the SUBSTRING function along with CHARINDEX seems costlier than the PARSENAME...

  Neverthless, thanks for adding this code piece 🙂

  --In 'thoughts'...
  Lonely Rogue

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 10, 2016 at 9:30 am

  #1877867

  Thanks for the script.