No announcements
Found 1602790 threads
-
3 VotesHow to eliminate digits after decimal point
use cast function to avoid decimals Select cast(sal as decimal (10,0)) from empAnswered | 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
-
0 Votes
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 TomAnswered | 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 -
0 Votes
Eliminate nubers after decimal
The multiple and divide by 10 will effectively give you 1 decimal place.Answered | 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 -
0 Votes
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 ...Answered | 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 -
0 Votes
ELIMINATE THE DECIMAL POIT FROM THE COLUMN....
Hi sir, my column contains some values with out decimal points like LLL, LLF, ZIR......LIKE THAT ...Answered | 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 -
0 Votes
How to eliminate the decimals?
I wanted to remove the 2 decimals from a numeric field.Answered | 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 -
1 Votes
how to count the number of digits before decimal value
Declare @d decimal(20,12)=123456.700000000000 select 1+FLOOR(LOG10(@d))Answered | 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 -
0 Votes
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 ...Answered | 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 -
3 Votes
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 ...Answered | 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 -
1 Votes
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.CAnswered | 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 -
0 Votes
how to get only 2 decimal point
Try the following way: select convert(decimal,datediff(second,'20120101',getdate())/(60.0 * 60.0) ) -- 8501 select ...Answered | 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 -
0 Votes
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.Answered | 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 -
1 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
.csv file ignoring decimal points
A decimal column is a decimal column - a computer will interpret 260 the same as 260.00.Answered | 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 -
2 Votes
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 ...Answered | 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 -
2 Votes
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 ...Answered | 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 -
0 Votes
Decimal to store 15 decimal places
If you use 20 on the left and 15 in the right : decimal (20,15).Answered | 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 -
1 Votes
Doubt on decimal data type
1 Byte - 8 Bits - Max Values (2^8 - 1) 255 - 2 Digits Maximum 2 Bytes - 16 Bits - Max Value (2 ^ 16 -1)65535 ...Answered | 4 Replies | 3823 Views | Created by Rajendra Kumbar - Tuesday, January 5, 2010 11:03 AM | Last reply by Rajendra Kumbar - Tuesday, January 5, 2010 12:02 PM -
3 Votes
Query does not display decimal points
Select CAST(60/11.0 AS DECIMALAnswered | 5 Replies | 20010 Views | Created by Dhaval Tamhane - Wednesday, October 27, 2010 5:48 AM | Last reply by Diogo Magro - Wednesday, August 26, 2020 9:42 AM - Items 1 to 20 of 1602790 Next ›
No announcements
