Posts by Douglas Soares • 1 point
1 post
-
0
votes3
answers36844
viewsA: return of decimal places in sqlserver queries
Hello, to bring the results with with decimal separator I did so. DECLARE @VALOR DECIMAL(15,2) DECLARE @X INT SET @VALOR = 2111113.55 SET @X = CASE WHEN LEN(@VALOR) BETWEEN 1 AND 6 THEN 3 WHEN…
sql-serveranswered Douglas Soares 1