Script to calculate Precision & Scale of a Decimal Value

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sreepathi1987 Default port Points: 1425 More actions · Answer 1

DECLARE @D DECIMAL(18,9)

,@S VARCHAR(20)

,@R VARCHAR(20)

,@Pos SMALLINT

SET @D = 5.1235698

SET @s-2 = CAST(@D AS VARCHAR(20))

SET @r = REVERSE(SUBSTRING(@S, CHARINDEX('.', @s-2) + 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: 2579 More actions · Answer 2

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 · Answer 3

SSC Guru

Points: 76202

May 10, 2016 at 9:30 am

Thanks for the script.