SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Vampire / Script to calculate Precision & Scale of a Decimal Value / Latest Posts

RE: Script to calculate Precision & Scale of a Decimal Value

Lonely Rogue — Fri, 22 Jun 2012 10:35:27 GMT

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 :)

RE: Script to calculate Precision & Scale of a Decimal Value

Sreepathi1987 — Tue, 19 Jun 2012 06:54:41 GMT

DECLARE @D DECIMAL(18,9) ,@S VARCHAR(20) ,@R VARCHAR(20) ,@Pos SMALLINTSET @D = 5.1235698SET @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 0ELSE SELECT LEN(SUBSTRING(@R, @Pos, 20)) AS Length

Script to calculate Precision & Scale of a Decimal Value

Lonely Rogue — Tue, 05 Jun 2012 13:14:00 GMT

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