No announcements
Found 4078051 threads
-
0 VotesSSIS unable to handle Numeric with 30 precision
Hi, I searched for microsoft document which says that the maximum size of Numeric till 38 precision. Today, I tried Numeric ...Answered | 2 Replies | 394 Views | Created by Vikas.Garg - Thursday, July 6, 2017 9:50 AM | Last reply by Vikas.Garg - Friday, July 7, 2017 10:48 AM
-
0 Votes
Getting the numeric field precision
I'm using code to extract a table's fields properties and I'm trying to figure how I can grab the precision of a numeric field. The ...Answered | 2 Replies | 4610 Views | Created by JazzyKat - Tuesday, January 24, 2006 10:02 PM | Last reply by JazzyKat - Wednesday, January 25, 2006 2:10 AM -
0 Votes
Validate numeric Value with dynamic precision?
Like 10 before precision and 10 after Precision... i want to save in database as ...Answered | 1 Replies | 7 Views | Created by Anonymous - Tuesday, January 29, 2008 9:21 AM | Last reply by Anonymous - Tuesday, January 29, 2008 10:12 AM -
1 Votes
Numeric Precision in Data Column
I was making some additional tests and it seems something related to the precision as the only columns giving me problems are those with NUMERIC(40,20). I've tested ...Answered | 8 Replies | 704 Views | Created by FcabralJ - Monday, February 10, 2020 12:09 PM | Last reply by Tim Roberts - Sunday, February 16, 2020 7:51 PM -
0 Votes
data conversion - numeric to string loosing precision
accomplished with a derived column transform, rather than a data conversion transform. There you have access to the SSIS expression language, with a ...Answered | 6 Replies | 7130 Views | Created by ajedi2k - Thursday, October 26, 2006 2:06 AM | Last reply by jaegd - Thursday, October 26, 2006 9:37 AM -
0 Votes
Formatting Numeric values in Report with precision
Hi, I am designing a report in SSRS which has Quantity and Price. The Quantity & Price precision could vary from 2 to 6 which is open for user to ...Answered | 3 Replies | 3687 Views | Created by Mridul Asthana - Friday, May 15, 2009 10:47 AM | Last reply by Mridul Asthana - Friday, May 15, 2009 4:10 PM -
0 Votes
Floating Point Precision to 30 figures
Hi Guys, I am working on a 64bit windows environment and I am trying to get a precions type which will cope with approx 30 ...Answered | 3 Replies | 4330 Views | Created by HarryBedi - Thursday, April 22, 2010 12:36 PM | Last reply by eryang - Wednesday, April 28, 2010 9:09 AM -
2 Votes
ADO.NET DataTable NUMERIC Precision and Scale?
or scale. I think you want to execute the command for format only in a more direct way with SqlCommand.ExecuteReader. You can pass in the CommandBehavior ...Answered | 2 Replies | 10050 Views | Created by Mike C_1 - Sunday, October 3, 2010 5:52 PM | Last reply by Mike C_1 - Tuesday, October 5, 2010 3:03 AM -
2 Votes
Problem with numeric precision with DECIMAL(28,14) variables
Hi pstr You're nearly there: The resulting precision should be (57, 28) as you've calculated, That's 29 digits to the left, ...Answered | 7 Replies | 5887 Views | Created by pstr - Wednesday, September 2, 2009 9:08 AM | Last reply by Ewan - Wednesday, September 2, 2009 2:58 PM -
0 Votes
WebMatrix numeric type has 0 precision
User-523471561 posted I created a column in SQL CE database with "numeric" type, precision 10 and scale 5. Then, I saved the ...Answered | 2 Replies | 28 Views | Created by Anonymous - Thursday, June 16, 2011 8:15 PM | Last reply by Anonymous - Friday, June 17, 2011 12:36 AM -
2 Votes
SSIS: Convert Numeric to Int
Okay, I dont know why DB2 Numeric and SQL Numeric values are not matching, to me they should match in SSIS too.And i cant test it right now Any ...Answered | 10 Replies | 13348 Views | Created by Jey-YoYo - Tuesday, October 11, 2011 9:41 AM | Last reply by Jey-YoYo - Tuesday, October 11, 2011 1:01 PM -
0 Votes
Numeric (19,5) increase precision to 7 decimal places
numeric (17,7), I'm not certain of the technical details, but think float is stored in x bytes, and I wonder if reducing the total number of digits (19) to 17 and ...Answered | 6 Replies | 6541 Views | Created by vsla - Friday, June 16, 2017 4:26 PM | Last reply by Erland Sommarskog - Monday, June 19, 2017 10:34 PM -
2 Votes
SSIS Excessive Scale/Precision Flatfile Destination
;unlimited" precision. Very clearly, the data hitting the file is not withAnswered | 7 Replies | 6709 Views | Created by ManifestConnect - Tuesday, November 20, 2012 6:14 PM | Last reply by ManifestConnect - Monday, November 26, 2012 4:21 PM -
1 Votes
SSIS, empty numeric columns populated with previous numeric column value
Hi InusC, I am unable to reproduce the issue, but to avoid the issue, you can use the following steps: Set the data type of ...Answered | 5 Replies | 1735 Views | Created by InusC - Thursday, January 16, 2014 12:46 PM | Last reply by Mike Yin - Wednesday, January 22, 2014 7:54 AM -
0 Votes
ssis handle errors?
Look for precedence constraints and event handlers in SSIS to get more ways to handle errors Nitesh Rai- Please mark the post as ...Answered | 1 Replies | 3569 Views | Created by BandSr - Friday, July 1, 2011 2:50 PM | Last reply by Nitesh Rai - Friday, July 1, 2011 3:25 PM -
0 Votes
Precision problem on division of two numeric values.
In your second select you are casting value @PoSumExcVAT to numeric without specifying precision and scale, so your value is converted to ...Answered | 3 Replies | 3199 Views | Created by Yogesh Bhadauriya - Friday, July 29, 2011 8:02 AM | Last reply by Surendra Nath GM - Friday, July 29, 2011 8:58 AM -
0 Votes
SSIS Integration - Text to Numeric
Show some example values (f.e. are you using 10,1 or 10.1)... and post the error. This works for me (with a correct number as ...Answered | 3 Replies | 1984 Views | Created by cowboyjunkie78 - Friday, November 16, 2012 1:13 PM | Last reply by SSISJoost - Friday, November 16, 2012 10:23 PM -
0 Votes
Converting from NVARCHAR to NUMERIC in SSIS
Hi, Please, check the regional settings for numeric values on your server (and Workstation). For example, if your decimal separator is set to ...Answered | 2 Replies | 5202 Views | Created by lilutchay - Monday, May 13, 2013 1:21 PM | Last reply by Mike Yin - Friday, May 17, 2013 4:43 AM -
0 Votes
"Unable to handle exeption"
only worked on my computer but in my co-workers' computer it didnt, I started receiving an "Unable to handle exception" error message. Since the code worked ...Answered | 1 Replies | 5962 Views | Created by Edgar J_ - Friday, February 3, 2006 6:19 PM | Last reply by PPradeep - Wednesday, February 8, 2006 7:44 PM -
0 Votes
precision problem on division of two numeric values
1.000000937196356. Even more precise than excel. Do you have any idea why i have to re-define datatype for InvoiceValue, which is already numeric(12,2) on table ...Answered | 3 Replies | 4 Views | Created by Anonymous - Friday, July 29, 2011 3:34 AM | Last reply by Anonymous - Friday, July 29, 2011 3:59 AM - Items 1 to 20 of 4078051 Next ›
No announcements
