No announcements

### How to eliminate digits after decimal point

use cast function to avoid decimals Select cast(sal as decimal (10,0)) from emp
| 3 Replies | 7285 Views | Created by vishveshk - Monday, June 21, 2010 1:01 PM | Last reply by Rajasekhara Reddy - Monday, June 21, 2010 4:45 PM

### How to validate three digits before decimal and after decimal point six digits in SQL Server

.]%' Then 'Invalid'  -- must be only digits and optional decimal point Tom
| 11 Replies | 4036 Views | Created by How to validate 3digit before decimal after 6digit - Friday, February 19, 2016 6:20 AM | Last reply by Tom Cooper - Monday, March 7, 2016 3:19 AM

### Eliminate nubers after decimal

The multiple and divide by 10 will effectively give you 1 decimal place.
| 6 Replies | 3328 Views | Created by Gaurav 17 - Wednesday, July 6, 2011 6:12 PM | Last reply by Darren Gosbell - Thursday, July 7, 2011 5:06 AM

### SSRS 2012 Rounding function - forcing to have 3 digits after decimal point all time

Hello All, I need the data to be formatted as below. something like forcing the value to have always 3 digits after decimal point ...
| 1 Replies | 6507 Views | Created by Karthikeyan Shanthakumar - Thursday, September 20, 2012 3:59 PM | Last reply by Syed Qazafi Anjum - Thursday, September 20, 2012 8:41 PM

### ELIMINATE THE DECIMAL POIT FROM THE COLUMN....

Hi sir,           my column contains some values with out decimal points like LLL, LLF, ZIR......LIKE THAT ...
| 13 Replies | 2986 Views | Created by SHYAM GUNDU - Monday, July 25, 2011 2:29 AM | Last reply by Krishna Rajeesh - Monday, July 25, 2011 4:00 AM

### How to eliminate the decimals?

I wanted to remove the 2 decimals from a numeric field.
| 1 Replies | 4162 Views | Created by Huyenhall - Wednesday, June 17, 2009 7:39 PM | Last reply by Sandeep Babbar - Thursday, June 18, 2009 10:31 PM

### how to count the number of digits before decimal value

Declare @d decimal(20,12)=123456.700000000000 select 1+FLOOR(LOG10(@d))
| 5 Replies | 6323 Views | Created by gvj - Thursday, November 6, 2014 6:00 PM | Last reply by Jingyang Li - Friday, November 7, 2014 5:06 PM

### point after decimal wont count in sql server 2012

datatype im using in sql table is numeric(18,0) allow null  Data type numeric(18,0) indicates a precision of 18 total digits ...
| 2 Replies | 725 Views | Created by Pratikpandya83 - Sunday, July 10, 2016 4:03 PM | Last reply by Dan Guzman - Sunday, July 10, 2016 6:28 PM

### Check Constraint on decimal: restrict user to enter more than 1 digit

= 0.00)); >>  Now, While inserting the data into the table especially in salary_amt column..I want to restrict the user to enter only one digit after ...
| 14 Replies | 8937 Views | Created by Rahul Kumar (Rahul Vairagi) - Thursday, January 5, 2012 10:35 AM | Last reply by Gert-Jan Strik - Friday, January 6, 2012 7:58 PM

### How to calculate max value for decimal type

Max value 12 digits before decimal and 6 digits after the decimalWith Thanks and Regards Sambath Raj.C
| 4 Replies | 43031 Views | Created by Isolda - Friday, May 25, 2012 11:41 PM | Last reply by Sambath Raj.C - Monday, May 28, 2012 10:10 AM

### how to get only 2 decimal point

Try the following way: select convert(decimal,datediff(second,'20120101',getdate())/(60.0 * 60.0) ) -- 8501 select ...
| 6 Replies | 2718 Views | Created by iamnewtosql - Thursday, December 13, 2012 8:48 AM | Last reply by Kalman Toth - Thursday, December 20, 2012 10:03 AM

### Import from excel coverts 2 digit decimal data to several digit decimal data

I'll wager it's DT_R8, which is a "double" which is a floating point representation of a number.
| 4 Replies | 3460 Views | Created by Devster - Tuesday, March 5, 2013 2:20 AM | Last reply by Todd McDermid - Thursday, March 7, 2013 5:52 PM

### having 3 decimal points in the output

Hi roma_victa, From your scenario, you would like to get different results with different decimal points based on the values of ...
| 4 Replies | 1281 Views | Created by roma_victa - Tuesday, October 25, 2016 11:13 AM | Last reply by roma_victa - Thursday, November 10, 2016 12:26 PM

### Convert string to decimal, Problem with decimal point

Hi everybody, I have a column "KBETR" in my dataset which contains a net value as string with a "point" as decimal seperator (english Server ...
| 3 Replies | 2562 Views | Created by Lars Kristian Michel - Friday, July 5, 2013 7:52 AM | Last reply by Lars Kristian Michel - Friday, July 5, 2013 9:10 AM

### .csv file ignoring decimal points

A decimal column is a decimal column - a computer will interpret 260 the same as 260.00.
| 3 Replies | 3031 Views | Created by anki2010 - Friday, August 31, 2012 5:07 PM | Last reply by Todd McDermid - Friday, August 31, 2012 11:08 PM

### How to decrease decimal precision

This will give you a variable-width storage format for all your columns: ALTER TABLE MyTable REBUILD WITH (DATA_COMPRESSION = ROW) That error message means that you ...
| 3 Replies | 1509 Views | Created by TC Kevin - Monday, April 22, 2013 9:21 PM | Last reply by davidbaxterbrowne - Monday, April 22, 2013 9:29 PM

### how to convert Time format HH:MM:SS to decimal point

Try declare @hms varchar(8) set @hms = '03:46:12' declare @hours decimal(14,2) declare @minutes ...
| 8 Replies | 36589 Views | Created by iamnewtosql - Thursday, December 13, 2012 8:02 AM | Last reply by TPN55 - Sunday, May 22, 2016 11:26 PM

### Decimal to store 15 decimal places

If you use 20 on the left and 15 in the right : decimal (20,15).
| 6 Replies | 1218 Views | Created by PedroRiver - Wednesday, February 21, 2018 1:12 PM | Last reply by Ousama EL HOR - Wednesday, February 21, 2018 2:14 PM